Re: left outer join on multi tables

Taking a second look. I see a few places I made a mistake. :-(

> CREATE VIEW your_view AS
              ^^^^^^^^^
> SELECT N.first_name,
>        N.last_name,
>        A.street,
>        A.city,
>        W.hour,
>        ....
> FROM   person P
> LEFT JOIN name N ON (P.namid = N.id)
            ^^^^
> LEFT JOIN address A ON (P.addressid = A.id)
            ^^^^^^^
> LEFT JOIN work W ON (P.workid = W.id)
            ^^^^
> ;

Hopefully this works a little better.

Regards,

Richard Broersma Jr.