[DUG-DB]: SQL

[John Christenhusz]

G'day folks,

Why does the following query return any redundant records (e.g. 83 out of
446)

and when I replace SELECT * by DELETE; it deletes ALL 446 records!!!

Any ideas?

SELECT *
FROM RE_Property p
WHERE p.id not IN 
  (     SELECT c.id
        FROM RE_Client c )



TIA

John.

winmail.dat