Running Access SQL outside of Access

[skyhighe]

Is there any way to run Access SQL outside of access like in an Oracle database. I have some fairly convoluted sql that needs to be debugged but the inner join/outer join verbage causes it to gag in any of the other databases I have tried...

Thanks in advance

 

[JimHorton]

sky,
My suggestion is to get used to using 'where' clause for joins, get used to separating where clause sections with parenthesis. The only other option is an odbc link to the Oracle tables, but the query will run very slow if you have a lot of joins.

My first complaint about Oracle was that the Join keyword was not supported, but it wasn't that difficult to learn do the same thing with the Where clause. I take that back--it was a bit of a pain X-)
--Jim