[AccessD] Quick Update Solution

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



More information about the AccessD mailing list