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.

John Kim wrote:
structures (field names and datatypes - you only need to show us the ones
that are relevant to your questions) and sample data in tabular format,
followed by desired results from that sample data, also in tabular format.

On Nov 10, 3:29*am, "Bob Barrows" <reb01... (AT) NOSPAMyahoo (DOT) com> wrote:
tblCurrentIssueNo
week_no - number field.

tblStudyGuide
attemptedIssueNo - number field