MapInfo Pro Developers User Group

Could anyone assist please with the following simple SQL - I'm a learner :-)

I have the following list of LOC id's that I need to filter down from a table of 1000's. I could sort them then select each one manually to create a selection but it will take for ever. I'm sure SQL is faster?

Table is called "sl"

LOC column is "id"

List is;

LOC000008651780

LOC000084794689

LOC000076297627

LOC000093647788

LOC000039555897

LOC000050352269

LOC000104959029

LOC000011620073

LOC000034024768

LOC000001693699

LOC000094652392

Hi Dale,

If I understand your requirement correctly, you are trying to select specific records from a large table and produce a sub table of these specific records?

If that is the case, you can use the below sample SQL syntax in MapInfo Pro's Query Select window.

Country = any("GHANA","MALI","IRAQ")

In the example above, Country is the name of the ID field, and the names of the specific countries to be selected are contained within double quotation marks between brackets.

Hope this helps!