checking against issue numbers
- From: John Kim <jinumarketing@xxxxxxxxx>
- Date: Thu, 10 Nov 2011 00:45:33 -0800 (PST)
I run online based study guides program. I email out new issues every
week, mon / wed / friday.
I have new sign ups every week. and each of these sign ups, I need to
follow up on the issues subscribers haven't attempted.
In one table, I have last issue numbers sent out so far. So Week #1 -
issue 12, Week #2, issue 9, Week #3, issue 6, and so on.
I download each subscribers log in and study guide attempt record thru
online MySQL table, and import to MS SQL.
I need to check these records against above mentioned table. So for
example, if Week #1 signed up student has attempted issue 1, 2, 3, 4,
7, and 8, but didn't do all of issues sent up to issue 12, I need to
come up with SQL code that will generate issue 5, 6, 9, 10, 11, and
12.. which are issues this student has not attempted as of yet.
Can anyone tell me / help me with SQL code that will check these
attempted issue number records against issues sent out thus far table
record and come up with issues not attempted as of yet??
.... let's say, the table says Week #2 is sent to up to issue #9. But
downloaded MySQL records show only issue 1, 2, 3, 5, and 8 are
attempted.. Then SQL code should check these 1, 2, 3, 5 and 8 against
Up to Issue 9 in the table.. in this case up to Issue 9, and come up
with Issue 4, 6, 7, 9.
The table only has the data of issue 9; the last issue number sent out
so far.. Another table shows records of issue numbers of all attempted
So issue 9 should be checked against issue 1, 2, 3, 5 and 8.. and come
up with 4, 6, 7, 9.
Could anyone please help me with SQL code to compare these two
table .. and come up with issues not attempted??
- Prev by Date: checking against issue numbers
- Next by Date: checking against issue numbers
- Previous by thread: Re: checking against issue numbers
- Next by thread: checking against issue numbers