MI-L SQL selection

Dear list, I trying to select in following example. Select * from Streettable where City = “Stockholm” And City = “Gothenburg” And City = “Malmo” into Selection I can’t get any result from this, it says the syntax is right but I can’t get all into a selection How should it be done prop

MI-L sql selection

Dear Listers, I have a table of districts and a grid which is overlaid. I want to return each district with each map tile it intersects. The format I require when finished is Region_name; Tile_1; Tile_2; etc At present I am using this SQL Select DISTRICT_BOUNDARIES.NAME"DISTRICT", Region_1_grid

RE: MI-L SQL selection

en Vick Europa Technologies Ltd. http://www.europa-tech.com -Original Message- From: Sören Lindqvist [mailto:[EMAIL PROTECTED] Sent: 20 February 2004 11:50 To: [EMAIL PROTECTED] Subject: MI-L SQL selection Dear list, I trying to select in following example. Select *

SV: MI-L SQL selection

Hi all Thanks for the answers it worked. Soren -Ursprungligt meddelande- Från: Warren Vick, Europa Technologies Ltd. [mailto:[EMAIL PROTECTED] Skickat: den 20 februari 2004 13:06 Till: 'Sören Lindqvist'; [EMAIL PROTECTED] Ämne: RE: MI-L SQL selection Hello Soren, You'v

Re: MI-L SQL selection

Hi Soren Map Info does not want "And" if you are selecting from one field, but it rather wants "Or". So simple run the same query and put "Or" instead of "And". Regards, Norman Mabunda Manager: GIS and Databases [EMAIL PROTECTED] +27 12 312 0843 (Tel) +27 12 312 0642 (fax) +27 73 265 927

RE: MI-L sql selection

anada Ltd. (905) 660-8688 -Original Message- From: Bean, Nick (N) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:00 AM To: 'MI-L' Subject: MI-L sql selection Dear Listers, I have a table of districts and a grid which is overlaid. I want to return each district with e