Hi Uffe and all the other listers who have helped! I've nearly cracked this now, I can now get the query to select the correct Asset ID, out of the four tables.
However :p I can't seem to find a way to select the object from the corresponding asset_id and insert it into the new table. This means i can't hit find selection to go to the selected asset! Could someone please point me in the right direction! I've tried using SELECT ASSET_ID, OBJ FROM VALVES but this only returns to me the information that the object is originally a point value..... Thanks Jonathan >>> "Uffe Kousgaard" <[EMAIL PROTECTED]> 07/01/2004 13:51:48 >>> From: "Jonathan Gledhill" <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 2:36 PM > Is it possible to change from SELECT * > FROM VALVES > To SELECT ASSET_ID > FROM VALVES > > and repeat this and then append the four results tables together, would > this mean there would just be one field in the results table so they > could append? Yes. It goes like this: SELECT ASSET_ID FROM VALVES where asset_id=somevalue into tmp1 commit table tmp1 as "newtable" open table "newtable" SELECT ASSET_ID FROM HYDRANTS where asset_id=somevalue into tmp1 insert into newtable select * from tmp1 SELECT ASSET_ID FROM METERS where asset_id=somevalue into tmp1 insert into newtable select * from tmp1 SELECT ASSET_ID FROM PRV where asset_id=somevalue into tmp1 insert into newtable select * from tmp1 Kind regards Uffe Kousgaard www.routeware.dk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9776 ********************************************************************** CONFIDENTIALITY The information contained in this message and any attachments are intended solely for the use of the individual or entity to whom they are addressed. It may contain privileged or confidential information. If you are not the intended recipient you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender. Thank You This e-mail message has been swept by MIMEsweeper for the presence of known computer viruses. ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9781
