Hi,

I have 2 table in my database, all I need to do is select all records from one database that dont exist in the other.

The problem is I get repeating records, can anybody help?

Here is my sql:

SELECT * FROM personaldetails INNER JOIN dbo.ql ON personalDetails.applicationID = dbo.ql.applicationID
WHERE ( personaldetails.applicationid <> ql.applicationid
  ) ORDER BY personaldetails.applicationid DESC

You can use the MINUS operator.

SELECT columns_here FROM table_here
MINUS
SELECT columns_here FROM table2_here

Make sure the number and datatypes of the columns in both SELECT statements are identical and the columns in the WHERE clause must be in both SELECT statements.

Hi,

SELECT * FROM PERSONALDETAILS WHERE APPLICATIONID NOT IN
     (SELECT APPLICATIONID FROM ql)

Hope this works.



B. Anant

I did this many times to avoid dups when imported data. Try this:

SELECT * FROM personaldetails LEFT JOIN dbo.ql ON personalDetails.applicationID = dbo.ql.applicationID
WHERE ( ql.applicationid IS NULL --MEANING THERE IS NOW MATCHING RECORDS IN ql
  ) ORDER BY personaldetails.applicationid DESC

Thanks for all your replys