SQL subqueries newbie help
От | Alexei Chetroi |
---|---|
Тема | SQL subqueries newbie help |
Дата | |
Msg-id | 20030906110709.GA13384@uniflux-line.net обсуждение исходный текст |
Ответы |
Re: SQL subqueries newbie help
Re: SQL subqueries newbie help |
Список | pgsql-sql |
Hi All, I need a little help regarding writing some subqueries. For example I have a table "items" which contains columns: itemid, description; and another table "events" with columns: itemid, date, event. events.itemid references items.itemid. Table events contains events regarding some itemid's from table items, so there could be multiple events regarding one item from items table. for example: Table: items itemid description 1 Lamp 2 Desk 3 HiFi Table: events itemid event date 1 purchase 2003-01-01 1 repair 2003-01-03 1 repair 2003-02-05 2 purchase 2003-02-01 3 HiFi 2003-02-01 I'd like to write a query which returns following information regarding each item: item, date of very first event, very last event.Is this possible? I think I can write several SELECT queries and procces them by an application or possibly write some procedure, but what is better solution? PS: are there any books regarding complex SQL queries in electronic format?
В списке pgsql-sql по дате отправления: