Michael,

   The subselect

      Select obj
      from prcels where Cen_Code = "1"AND Subdivision = "2"

   in your query does absolutely return 1 record because you compare
parcels.obj with the results. You can use 'any' or 'all' if you want
to compare multiple results.

   Hope this help,

   Carlos


-----Mensaje original-----
De: Michel Van Asten [mailto:[EMAIL PROTECTED]]
Enviado el: mi�rcoles 4 de diciembre de 2002 16:39
Para: [EMAIL PROTECTED]
Asunto: MI-L MapBasic error message


Hi all,

When I execute this query in MapBasic I got the Error "SubQuery returned
more than one value" What does that mean ??

 Select * from prcels Where Processlevel = 0 AND obj Intersects(Select obj
from prcels where Cen_Code = "1"AND Subdivision = "2")  into pronoaff"

Regards,

Michel Van asten
Projections SPRL




---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4420


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4421

Reply via email to