Select of 2 tables using "left outer join"

From: "Catherine Germain" <catherine(dot)germain(at)mcnet(dot)ch>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Select of 2 tables using "left outer join"
Date: 1999-10-07 16:39:44
Message-ID: 7tjvnf$7b3$1@pollux.ip-plus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Help

I need some help.
I want to do a select on two tables for exemple A and B, but the information
on B
exist or not exist.
I'm use to use SQL Server there it's a left outer join.
Does someone know if that is possible with postgress, and if yes how...

Many thanks

Catherine

Browse pgsql-sql by date

  From Date Subject
Next Message raptor 1999-10-07 20:38:28 6.5.1 -> 6.5.2
Previous Message Peter Eisentraut 1999-10-07 15:25:46 How do I know if I'm in a transaction?