Please cc: the list when you reply to me - that way others can help too.
imam wrote:
If this is a left outer join, you could do something like:
SELECT
...
FROM
pe_pop_sr_posted_tran_head t1
LEFT JOIN
pe_pop_po_header t2
ON
t1.po_header_pk = t2.po_header_pk
LEFT JOIN
pe_pop_sr_posted_tran_det t
imam wrote:
The following is a sybase query and i am trying to convet it into
postgres but in postgres the join will be specified in from clause
and we cannot specify any logical operator
i would be grateful if you could tell me the solution for it
You don't actually say what your query is trying t
The following is a sybase query and i am trying to
convet it into postgres but in postgres the
join will be specified in from clause and we cannot
specify any logical operator
i would be grateful if you could tell me the
solution for it
SELECT t1.SR_TRAN_HEAD_PK AS ReceiptHeaderPK,
t1.A
