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? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly