I've just discovered a problem with the Generic Query Designer on my machine. When I do a simple join of two tabels it does not display in the SQL pane as standard syntax, so instead of SELECT a.1 from ainner join b on a.1=b.1It does SELECT a.1from a, bwhere a.1 = b.1I am doing this against an oracle 10g database, it will run the query, but I want the query designer to out put at standard SQLI am presuming that it is a setting in SSBIDS, but I don't know why it is doing this. Any suggestions?

When using the generic query design window, the query should be executed exactly as you entered it and no changes should be made by the designer. Are you saying that after you type the ANSI SQL statement above, that at some point the query designer rewrites your query to use the legacy joins in your second example? When are these changes applied? I've never seen the GQD manipulate a SQL statement andI certainly wouldn't expect it to modify P/L SQL. Please provide repro steps so Ican test this behavior. Paul Turley [Hitachi Consulting] SQLServerBIBlog.com

Hi Paul The problem occurs when you build the query using the visual query builder tool ie: the interface where you drag the tables, tick the coulmns and select the links. When you directly type the query in, it will accept either. But when you use the visual query tool, it defaults to non ansii. I have'nt tried this out against a MSSQL 2005 database, but I know the Oracle 10g database is set to accept no standard and non standard SQL. I wonder if the driver picks this up. It would be useful to overdide, any suggestions?

Hello I have noticed the same problem. When using an Oracle data source, I cannot get the Query Designer to produce 'ANSI' SQL. It is producing the old Oracle SQL syntax (e.g. outer joins are done with a + sign). Any further ideas in the last year or so since you posted this ? Thanks, Stuart Page

I'm having this problem on several of my team's machines but not on all. So, if anyone runs across an answer, help would be appricated.