0 Replies Latest reply: Aug 1, 2006 6:13 AM by 3004 RSS

    SQL standard outer join in production reporting

    3004
      <p>How/Where to configure the query generator in order to generateStandar SQL 92 query in case such as outer join.</p><p> </p><p>By default it generates outer join with (+) irrespective ofwhether the connection is oracle or not. ( I could do that inInteractive reporting while create connection files)</p><p> </p><p>Currently I am modifying the where clause to have a SQL standardjoin.</p><p>It generates this query</p><p>SELECT AMOUNT, CREDIT_AUTHORIZATION_NUMBER, CONTACT_FIRST_NAME,CONTACT_LAST_NAME From CREDIT, CUSTOMER WhereCREDIT.CUSTOMER_CREDIT_ID = CUSTOMER.CUSTOMER_CREDIT_ID(+)</p><p>but I wanted</p><p>SELECT AMOUNT, CREDIT_AUTHORIZATION_NUMBER, CONTACT_FIRST_NAME,CONTACT_LAST_NAME From CUSTOMER LEFT OUTER JOIN CREDIT ONCUSTOMER.CUSTOMER_CREDIT_ID = CREDIT.CUSTOMER_CREDIT_ID</p>