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.