Toad World® Forums

Ansi-92 JOIN


#1

I just load Toad for data analysts onto a new PC, The query builder is formating the SQL with Inner Joner

SELECT a.ACCOUNT_NUMBER AS cc, b.CIRCUIT_ID AS dd
FROM CPI_STAGE.CPI_NLAN b
INNER JOIN
CPI_STAGE.CPI_PRODUCT_INSTANCE a
ON (b.PRODUCT_INSTANCE_ID = a.PRODUCT_INSTANCE_ID)

On my old PC with Toad for Data anlalysts, the query builder formated the sql to the
ansi-92 join standard

SELECT a.ACCOUNT_NUMBER AS cc, b.CIRCUIT_ID AS dd
FROM CPI_STAGE.CPI_PRODUCT_INSTANCE a, CPI_STAGE.CPI_NLAN b
WHERE (a.PRODUCT_INSTANCE_ID = b.PRODUCT_INSTANCE_ID)

Does anyone have any idea on an option to adjust to change the formating in the query builder to build Ansi-92 joins?

Message was edited by: craig.tystad_625


#2

There is a sticky button on the Query Builder that will retain your preference. It is the toolbutton with the ‘A’ on it.

Debbie


#3

Thanks, you are the greatest