Well I finally found an answer to my own problem. Why it won't work in the
first place I don't know, however if you encounter the <no join specified
between tables> and are using variables in place of the table and column
names this was the solution that worked for me. Create a new string variable
and enter the Select statement with variables and use the run command
statement to run the new variable:
tablerefined = path+".Cnty_Fips_Code"
Dim test as string
test = "Select * from _2000_HH,"+ path+" where _2000_HH.County_FIPS =
"+tablerefined+" into Selection"
Run Command test
Browse * From Selection
> -----Original Message-----
> From: Niemiec, Neal [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: MI-L <ERROR> no join specified between tables
>
> Hey GIS buddies,
>
> This one has me crawling from the ceiling. I am trying to do a join with
> two
> tables. One is a simple txt table and one a native MI table. When I copy
> the
> syntax from the MAPBASIC window into my mapbasic program and replace the
> appropriate where clause and column name with variables which look just
> like
> the syntax I get the - no join specified between tables -. I don't get how
> that can be when the variables are exactly the syntax missing from the
> join
> statement. Any help greatly appreciated.
>
> here is the syntax:
>
> path = Customer_Count_09_04_01
>
> tablerefined = path+".Cnty_Fips_Code"
> note tablerefined
>
> Select * from _2000_HH, path where _2000_HH.County_FIPS = tablerefined
> into
> Selection
> Browse * From Selection
>
>
>
> NEAL T. NIEMIEC
> GIS APPLICATION DEVELOPER
> (303) 706-4497
>
> ECHOSTAR @ INVERNESS OFFICE
> 90 Inverness Circle East
> Englewood CO 80112
>
>
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
