Re: [SQL] OUTER JOINs in PostgreSQL

On Wed, 02 Jun 1999, you wrote:
>I think that you are looking for something like:
>
>SELECT m.id, m.name, d.lastvisit, d.info
>       FROM master m, detail d
>       WHERE m.id = d.id;
>
>Jason
>

No, that way I get an inner join: in my example the result would be

id | name  | lastvisit | info
-----------------------------
1  | Alpha | Wed Jun 02 19:43:08 1999 CEST | blah blah
1  | Alpha | Wed Jun 02 19:45:08 1999 CEST | some more blah's

and I'm instead looking for this output:

id | name    | lastvisit | info-----------------------------
1  | Alpha   | Wed Jun 02 19:43:08 1999 CEST | blah blah
1  | Alpha   | Wed Jun 02 19:45:08 1999 CEST | some more blah's
2  | Beta     |                                                 |
3  | Gamma |                                                 |