Is there any way to update the object of one record using the object from another record without deleting the first. I have a table in Oracle that due to referential integritry contraints makes it difficult to delete records but I also need to be able to replace the spatial extent from time to time. Is there anything like: update table1 set obj = (select obj from table2 where row = x) where row = y Tim _______________________________________________________________________ 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.
