Exclude multiple rows

[junk]

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.