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 | |