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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
