• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

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 !!
0
chokka
Asked:
chokka
1 Solution
 
tomcahillCommented:
SELECT * from vw_340B Vw
     WHERE Vw.nameFirst NOT IN (select [First Name] as nameFirst from CP_340B)
0
 
chokkaAuthor Commented:
Thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now