>- see footer for list info -< Am having brain failure at the end of today.
I have a table with ID, name, address, postcode, email, etc I want to write a query to select DISTINCT emails from the db plus name, postcode and id numbers. Have tried DISTINCT SELECT DISTINCT top 5 Email, firstname, surname, telephone, address, postcode, id but give duplicates Have tried group by but no joy. Please could any kind soul point me in the right direction. (2 queries) Thanks Allan _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
