Re: MI-L Select Problem

[Sonya Nikosky]

You have to use the "any" type query to get genuine object -sad but true.
Like this:
Select Asset_ID, obj from MyTable where Asset_ID = any (select 
MyOtherTable.Asset_ID from MyOtherTAble)

Jonathan Gledhill wrote:

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!
 

"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
 

--
Sofia Nikolsky
JCH GeoInfo Solutions
(919) 493-9339
www.jchgis.com