Still need Help with Query

2000-11-02 Thread Kelly Matthews
maybe you can shed some light got it to work by doing this: (there could be an easier way) This query finds all the distinct ssn's. SELECT DISTINCT ssn FROM STUDENTS WHERE AIRPORT_CODE = 'AAE' AND testname = 'Driver Training' Then i loop through (actually 2 loo

RE: Still need Help with Query

2000-11-02 Thread Hayes, David
D]] Sent: Thursday, November 02, 2000 1:48 PM To: CF-Talk Subject: Still need Help with Query maybe you can shed some light got it to work by doing this: (there could be an easier way) This query finds all the distinct ssn's. SELECT DISTINCT ssn FROM STUDENTS WHERE