Exclude multiple rows
Posted by:
junk
Date: July 26, 2005 09:40AM
I have two tables, one "main" and one "events". The events table is filled with different dates and keys pointing on rows in main table. So there could be several dates for one main-row. I would like to select * from main and order all rows thru the events table. Last date first. I did a left join. The problem is I got a main-row for every matching date in the events-table. I wish to remove the duplicates. I havent found a way for doing that. Hope Im getting lucky here. Thx.
Subject
Written By
Posted
Exclude multiple rows
July 26, 2005 09:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.