Thanks All - the GROUP BY is the cookie!
Thanks also Daniel - that's just the job - basically I have a customer table and an orders table - I have done a LEFT JOIN so that I get all customers (some may not have ordered yet) BUT I only want one instance of the customer in my final table - it's a kind of "meet all needs" SELECT statement...
Thanks for your help...