You can use a subselect
Select * from Temp5 Where Lieu in (select ID_POINT from Temp6) into s_NomTable
If you index the columns Lieu and ID_POINT you will also speed up your process
Regards
Stuart
From: [EMAIL PROTECTED] To: [email protected] Subject: MI-L MapBasic SQL Problem Date: Wed, 23 Mar 2005 14:36:22 -0500
Hi, I try to select some data trought MapBasic between two different Table.
The first table contains the data I want to select if one field value is into another table field Value..
This is the "problematic code"
Select * from {Temp5,Temp6} Where Temp5.Lieu = Temp6.ID_POINT into s_NomTable
The 2 Tables Temps contain a lot of Data. The field ID_Point and Lieu contain the same type of Data with same format. It contain an Id number for a point. The Temp6 is a georeferenced one and I want to get only the Temp5 data associated to Temp6.
EveryTime I run the program, at this line, it crash and it tell me that Temp6.ID_Point is not define...
Some one can help me !?
Thanks
----------------------------------------- Remi Blanchette-Gobeil Stagiaire Universitaire
Hydro-Qu�bec <http://www.hydroquebec.com/images/logo_hq_couleur.gif> Plan de Maintenance Centre Administratif St-Bruno 705, boul. Clairevue Ouest Rez-de-Chauss�e St-Bruno de Montarville ( Qu�bec ) J3V 6B6
T�l Bell : 450-441-7200 ext 6098 T�l HQ : 0-441-6098 T�l�copieur : 450-441-7389 Cellulaire : 819-580-0444 Courriel : [EMAIL PROTECTED]
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15794
