Hi , I have a table: item location aaa 10 aaa 20 bbb 10 bbb 10 ccc 10 ccc 20
I need to select distinct items where locations are the same. So result set should look like: item loation bbb 10 Already spent 7 hours on this one. Thanks a lot / Alex __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
