Hi,
Can someone give me examples for the correct syntax for FULL OUTER JOIN, where each table
has some additional conditions. The docs don't give any complete examples :-(
I can only get it to work using subselects:
SELECT stock,o.ordercurrent,s.quantity FROM
(SELECT stock,ordercurrent FROM orderlines o WHERE o.theorder=' 4494' AND (o.type='P' OR o.type='T')) AS o
FULL OUTER JOIN
(SELECT stock,quantity FROM standingorders s WHERE s.account=' 15048' AND s.dayno=2) AS s
USING (stock)
Thanks
JohnT