January 28th, 2003, 02:39 PM
Join Date: Feb 2001
Time spent in forums: < 1 sec
Reputation Power: 13
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