Paul Black
pblack at hotmail.com
Mon May 12 15:31:55 CDT 2003
>INSERT INTO Table2 ( LINK_PT ) >SELECT Table1.LINK_PT >FROM Table1 >LEFT JOIN Table2 >ON (Table1.LINK_PT = Table2.LINK_PT) >WHERE Table2.LINK_PT Is Null; Hi Brett Works great Thank you Paul _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus