Krasavita (3/17/2011)
Hello, I need to delete records from table2 that are not in table1I have a table1 and table2
table1
DB, CODE, RATE, MAX(CONV_DATE) AS MaxConv_Date
FROM table1
table2
DB, CODE, RATE, Date
FROM
table2
I need to delete records from table2 that are not in table1
Thank you
EXCEPT will do a fine job on this. Have a look at it in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.