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