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