Hi, Select * From Table1,Table2 Where Table1.ID=Table2.ID Into NewTable
Gives you a mix of both tables...You can change the * into the name of columns (Tabl1.Col1, Tabl2.Col3) it should work to select only a few columns. Robin. -----Message d'origine----- De : Eoin O'Mahony [mailto:[EMAIL PROTECTED] Envoye : lundi 24 octobre 2005 15:57 A : MI-L Objet : MI-L update column Is there a way to use the update column function in MI6 to create more than one temporary column in the primary table, i.e. a number of other columns from the secondary table? Thanks Eoin O'Mahony **************************************************************************** ********* The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you have received this electronic message in error, please notify the sender or [EMAIL PROTECTED] This message has been swept by Anti-Virus software. **************************************************************************** ********* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18440 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18441
