starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work.
3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
