Outer Joins
От | Sharon Cowling |
---|---|
Тема | Outer Joins |
Дата | |
Msg-id | 200111130443.fAD4hd010549@lambton.sslnz.com обсуждение исходный текст |
Ответы |
Re: Outer Joins
Re: Outer Joins |
Список | 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 valuebut 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
В списке pgsql-general по дате отправления: