January 28th, 2003, 01:39 PM
how would i convert this to an ANSI/Postgres compatible query?
how do i convert this to ANSI/Postgres usable SQL?
here is an example of the end of a SQL statement that I need to convert. the SELECT clause is irrelevant (it was just too much to post).
i am kind of lost on what to do with the outer joins that i have on a table to a particular field for example ---- fax.gctyp(+)='FX'
offices.OffCo > 0 AND
(phone.publish='y' OR phone.publish='Y' or phone.publish is null) AND
offices.offno IN(SELECT offno FROM offcnty WHERE cnty_id=4)
ORDER BY officeName,offNo,ph_conseq,fx_conseq,mngr_conseq
i am trying to write a converter to do this for all of my code, i am just unsure how to do some of this in a processable, efficient way
January 28th, 2003, 02:04 PM
January 28th, 2003, 03:35 PM
k, read it...
didnt read where it described an outer join to a column like
which is what i am having problems on...
i know how to write outer joins from oracle to ansi compliant, just having problems with certain situations like the one stated above.