General information
Forum:
Microsoft SQL Server
Hi Group
I would like to find the records in the jw2_studemo_suniq_ident view, that do not have a matching ident in the catcboe_students table.
There are 72 matching records so I should get back 384 records
This
SELECT * FROM jw2_studemo_suniq_ident
Returns 456 records in zero seconds
This
SELECT * FROM catcboe_students
Returns 1801 records in zero seconds
This was built using the view designer in the Enterprise Manager
SELECT dbo.jw2_studemo_suniq_ident.suniq AS home_suniq,
dbo.jw2_studemo_suniq_ident.ident,
dbo.catcboe_students.ident AS catc_suniq
FROM dbo.catcboe_students,
dbo.jw2_studemo_suniq_ident
WHERE (NOT (dbo.jw2_studemo_suniq_ident.ident IN
(SELECT ident
FROM dbo.catcboe_students)))
Returns 691,584 records in 6 Minutes 53 seconds
Thank you for your help
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only