Search results

No, I want the records from the Compensation table that don't match a row in the Site table. I added another table to limit to only current employees, but I'm still getting this; COMP_ID SITE_ID EMPLOYED 173 5 yes 203 62 yes 219 69 yes I should...

Beetle, it just about there. After looking at you query a little more. I like that it give me a list of people that have a compensation record with a Site ID, but no record in the SiteWorked Table for that compensation record. But what I also need is; I have record CompensationTable, CompID of...

Bettle, thanks for the reply. Thought I tried something like that earlier, but tried yours. It returns all the record that DON'T have a SITE_ID in the SITE Table. I only need to see somebody that in the Compensation table that doesn't have the CompSite found in the Compensation table that NOT in...

It an old design and needs to limb along a little longer. From the Compensation table; who's being paid now and what site they are currently at. The Site table; contains the current and past sites they have been compensated for. So, I need to find the current Compensation record that doesn't...

I have tow tables, Compensation and Site, that have a primary key that match. The site table has multiple rows for 1 record in the compensation table. I trying to see if a record in the compensation table where the site id's don't match what's in the Site table. For Example: In the...