Dear list Is there a way (or tool available) to take a column from a sql join and append it to one of the base tables involved in the join (similar to the 'Append Rows' function) rather than saving the query result table, closing down the base table, opening the query table and changing it's name to overwrite the existing base table? I hope you follow that. Help greatly appreciated. Mark Percival IT Client Officer Cultural Development Division City Development Directorate Coventry City Council mailto:[EMAIL PROTECTED] Tel: 024 7683 2540 Fax: 024 7683 2461 This email, including any files transmitted with it, is confidential and intended solely for the use of the individual to whom it is addressed. The Recipient of this message must verify with the author that the contents of this message are correct and accurate. Any views or opinions expressed by the sender of this message do not necessarily represent those of Coventry City Council. If you have received this email in error please be advised that any use or disclosure of the information contained within it is strictly prohibited. Please notify the sender. ________________________________________________________________________ This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.