chokka
asked on
SQL NOT EXist In Another Table - Query
SELECT * from vw_340B Vw - This returns 68 Rows
select * from CP_340B - This Returns 45 Rows
I have to find the difference by FirstName
SELECT * from vw_340B Vw
WHERE Vw.nameFirst NOT EXISTS IN (select [First Name] as nameFirst from CP_340B)
Any syntax help , please !!
select * from CP_340B - This Returns 45 Rows
I have to find the difference by FirstName
SELECT * from vw_340B Vw
WHERE Vw.nameFirst NOT EXISTS IN (select [First Name] as nameFirst from CP_340B)
Any syntax help , please !!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER