Distinct Join

[DaveEverFade]

I have 2 tables as follows:

 

Customer:

cust_id

cust_name

 

Orders:

order_id

cust_id

 

I need to have a distinct select of the these but to only bring back one result per customer. This is what I have

 

SELECT DISTINCT * from Customer LEFT JOIN Orders on (Customer.custid = Orders.cust_id)

 

The only problem is that I get more than one result for each customer if there is more than one entry for said customer in the Order table.

 

The above is only a simplified example to try to explain my issue. Essentially I need the sql structure to remain as it is but need some kind of way of getting the LEFT JOIN to be distinct.... Any ideas?

 

Dave

[DaveEverFade]

Oh... And please don't suggest SELECT DISTINCT * from Orders... etc etc....

[Barand]

Not tested, but

 

SELECT c.customer_name, o.order_id

FROM customer c LEFT JOIN orders o ON c.cust_id = o.cust_id

GROUP BY c.customer_name