checking against issue numbers

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
issue.

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??

thanks.
.

Relevant Pages

  • checking against issue numbers
    ... I run online based study guides program. ... I have new sign ups every week. ... Can anyone tell me / help me with SQL code that will check these ...
    (comp.databases.ms-sqlserver)
  • checking against issue numbers
    ... I run online based study guides program. ... I have new sign ups every week. ... Can anyone tell me / help me with SQL code that will check these ...
    (comp.databases.ms-sqlserver)
  • Re: Olive Garden
    ... My town was 200 when we first moved here; it's growing, but we still have to drive a long ways to shop; to shop, we take our choice: 1) 7 miles - Walmart with unacceptable produce and don't know whether they will have what ... online because we were shopping online for it and were able to make price comparisons and it was what we wanted. ... UPS, DHL, USPS, Fedexpress -- they are getting lax in their deliveries. ...
    (rec.food.cooking)
  • Re: what kind of UPS will work best?
    ... there are basically two types of UPS' around: ... The online version is much more expensive but also much better in critical conditions. ... a storm happened and the power surge blew me off-line. ... All APC I have seen failing were of the fly-by type, all other were the online version. ...
    (freebsd-questions)
  • Re: what kind of UPS will work best?
    ... there are basically two types of UPS' around: online and stand-by or fly-by. ... a storm happened and the power surge blew me ... I do not think that it is a good advice to go for 10 second uptime. ...
    (freebsd-questions)