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
