MI How can I use SQL in Mapx

[dengsui]

Dear friends:

    first ,I am sorry my English is poor! because I am a Chinese

   

    I have used SQL in Mapinfo more than one year

    in mapinfo, I can use the following SQL statement

        exp:

Select * From customers
  Where obj Within Any(Select obj From states
     Where state = "NY" or state = "CT" or state = "MA")

 

   Q1: How can I do the statement in Mapx3?

   or: How can I operate to realize the function in Mapx3!

     

   note: 1.both the "customers" and states are mapinfo tables

         2.I use Mapx3 in VB5

 

            

            thank you!

   E-mail:[EMAIL PROTECTED]