74fa8b4e   
   From: reb01501@NOSPAMyahoo.com   
      
   John Kim wrote:   
   > 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.   
   I don't know how you expect us to be able to help without providing us table   
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)