join keyword in user SQL

[Oskar]

a user SQL statement like____select name from lastnames join firstnames on lastnames.id = firstnames.id____creates a ^DB access:Unexpected text at end of SQL query. "join" ^____of course I can rephrase:____select name from lastnames, firstnames where firstnames.id= lastnames.id____Because I will have to do a lot of setReplace() in the where clause, I would prefer to have a as ^clean^ intial where as pssible.____So, back to the join ... any chance to that to work?____Thanks__Oskar ____

[kfleming]

I just did some testing and you are correct that this does not work. Our ODBC interface needs to be updated to the latest ANSI standard for this syntax to be accepted. I realize that we are a bit behind the times...____Kathleen__R&R Support____

[Assignment Define]

I use R&R 10+ with SQL 2000 and use complex Ansi Sql queries.__I.e. Left outer joins ,(Nolock) Hints etc. ____To stop the error you mention just add an: Exec(^^);__at the top of the script and add all your SQL script below as normal.____It seems to change the way the sql is parsed and works with all the SQL statements I use.____Hope this helps.____Andrew__

[kfleming]

That is a simple creative and great suggestion!____Kathleen__R&R Support

[Oskar]

Thanks Andrew, that helped____Oskar