OK, say I have a result table that looks like this:

Code:
1 Item    1084985159 Test 
3 Item3  1084984893  Test2
2 Item2  1084984864  Test3
2 Item2  1084984849  Test4
1 Item    1084984821 Test5
See the column that contains 'Item<something>' (Like Item or Item3, etc.)? What I want to do is only get the first occurrence of any item and just get that row. After that, I don't want to get any more rows that contain that same item value. I tried messing with DISTINCT but couldn't seem to get that to work. Basically, I'm trying to get it to return this instead:

Code:
1 Item    1084985159 Test 
3 Item3  1084984893  Test2
2 Item2  1084984864  Test3
My query contains a bunch of LEFT JOIN's (there's actually a lot more data than this from different tables). I just want 1 row for each 'Item<something>' entry.

Thanks for any assistance.