| From: | Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Outer Joins | 
| Date: | 2001-11-13 04:43:00 | 
| Message-ID: | 200111130443.fAD4hd010549@lambton.sslnz.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
I come from an Oracle background and have noted that postgres 7.1 supports outer joins...but I'm not sure of the syntax. Note below in the first AND clause the (+) next to k.permit_id, I need to get the nulls back as well as the value but I get an error when I use (+)
SELECT t.permit_id, t.issue_date, t.issued_by, t.location, t.purpose ||' '|| t.subpurpose as spurpose, t.date_from, t.date_to, t.permit_conditions, t.other_info, k.key_code, p.person_id, p.firstname ||' '|| p.lastname as name
FROM person p, forest_permit t, permit_key k
WHERE p.person_id = t.person_id 
AND t.permit_id = k.permit_id(+) 
AND p.lastname LIKE 'Bloggs' 
AND p.firstname LIKE 'Joe'
ORDER BY t.issue_date
Best Regards,
Sharon Cowling
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-11-13 07:07:17 | Re: [general] Permissions | 
| Previous Message | Manuel Duran Aguete | 2001-11-13 03:01:49 | Strange Performance Problem. |