Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Selecting records NOT incl. in other tables.

Author  Topic  sonic Starting Member 11 Posts Posted - 2001-04-02 : 15:05:52 Hey there! Thanx for reading this. This should be fairly straigtforward, but Im having trouble with it. I'm trying to get records from a table named licensed_role that do not match up with records from a table named current_license. Inbetween is a join from licensed_role to people_role and an additional where clause for the people_id field. What I need is all license_types in licensed_role for a person that do not have a identical value in current_license. So far I have this... SELECT DISTINCT lr.license_type FROM (licensed_role lr INNER JOIN people_role pr ON lr.role_type = pr.role_type) LEFT OUTER JOIN current_license cl ON lr.license_type = cl.license_type WHERE pr.people_id = '200003171420339700' AND cl.license_type <> lr.license_type This just returns no values (im sure because of the last join and the cl.license_type <> lr.license_type contradiction. But I know thats wrong. Its driving me crazy... plz help! J'son