Gareth Haven't time to test this or set up data for it. How about:
Select * from table1, Table2, Table2 ... Where .... - but you need a join condition, (where) something in 1 table is different from that same something in the others, and this assumes that all 3 tables have same structure but differing recs) Then: Insert into AppendToTable ( Select * from selection) ' or ... From csrSelect from above, if you've selected into a cursor HTH Terry McDonnell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phillips, Gareth (Cartographics) Sent: 23 March 2006 11:31 To: Terry McDonnell Subject: [MI-L] Appending multiple tables to a table Hi, can anyone tell me if there is a way to append multiple tables to a table at once, rather than appending tables individually? regards, Gareth Phillips <<...OLE_Obj...>> Cartograffeg - Cartographics Llywodraeth Cynulliad Cymru - Welsh Assembly Government Ffôn - Tel: 02920 821558 Ffacs - Fax: 02920 823080 e-bost - e-mail: [EMAIL PROTECTED] Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol ac nid o reidrwydd fel datganiadau neu sylwadau gan Gynulliad Cenedlaethol Cymru, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig ag ef. Any of the statements or comments made above should be regarded as personal and not necessarily those of the National Assembly for Wales, any constituent part or connected body. The original of this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Energis in partnership with MessageLabs. On leaving the GSi this email was certified virus-free. Mae fersiwn wreiddiol y neges e-bost hon wedi'i sganio am feirysau gan wasanaeth sganio feirysau Mewnrwyd Ddiogel y Llywodraeth (GSi) a ddarperir yn arbennig gan Energis mewn partneriaeth â MessageLabs. Wrth i'r neges e-bost hon adael GSi, ardystiwyd nad oedd firws ynddi. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
