left outer join on multi tables

Поиск
Список
Период
Сортировка
От quickcur@yahoo.com
Тема left outer join on multi tables
Дата
Msg-id 1160542276.013714.300220@e3g2000cwe.googlegroups.com
обсуждение исходный текст
Ответы Re: left outer join on multi tables  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-general
Hi, here are my tables

table name
{
   id integer primary key
   first_name text,
   middle_name text,
   last_name text
}

table address
{
   id integer primary key
   number int,
   street text,
   city text,
   state text
}

table work
{
   id integer primary key
   hours text,
   shift
}

table person
{
    id integer primary key
    namid integer references name(id),
    addressid integer referenes address(id),
    workid integer references work(id)
}
nameid, addressid or workid in person table may be empty.

I would like to make a view which shows all information about a person
in one row

first_name, last_name, street, city, workhours, ...

In the peron table, if  the workid, addressid, or nameid is empty, just
do not display the correspodent information.

I think I need left outer join, but I do not know how to use it. Could
anyone help?

Thanks,

qq


В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: more anti-postgresql FUD
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: restoring a file system backed-up data dir