SQL query - comparing content of two fields

[n0nick]

I want to write a SQL query that compare content of two fields, and if the content is different, content from Table 2 is going to be updated to Table 1.

This is working great with this SQL query:

UPDATE Table2 INNER JOIN Table1 ON Table2.ID = Table1.ID SET Table1.Adress = [Table2].[Adress]
WHERE (((Leverandører.Adress)<>[Table2].[LevAdresse2]));

But this query only works if both fields are NOT empty. Lets say Table1 field is empty, and Table2 field is not empty for the same ID, then it should copy content from Table2 to Table1, but it doesn't do that..can anyone help??

 

[PHV]

WHERE Nz(Leverandører.Adress)<>[Table2].[LevAdresse2];

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[n0nick]

Thank you very much for quick answer Have a very nice day