DISTINCT STATMENT HELP

[fazzfarrell]

I have put the following statment:

 

<code>

SELECT DISTINCTOrders.ID, Orders.OderNum, Orders.ProdCode, Orders.ProdeName, Orders.ProdePrice, Orders.Supplier, Orders.OrderDate, Orders.Payment, Orders.QTY, Orders.Sent, Orders.OrderTotal, Orders.`Size`, Orders.Colour, customer.Customer, customer.Orderid

FROM Orders, suppliers, customer

WHERE suppliers.Email = colname AND Orders.Supplier = suppliers.Supplier AND Orders.Payment = 'YES' AND Orders.OderNum = customer.Orderid

ORDER BY Orders.OrderDate DESC

<CODE>

 

The order no col can have eg 6 order numbers all the same- so I want to display the order no only once on the repeat region but as the other cols have other information it shows up everything! How do I change my statement to only show one copy of each order number?

[Yesideez]

There's no space after the DISTINCT keyword.

 

btw, You need square [ ] brackets when using the CODE tag on here.

[fazzfarrell]

Thanks

 

I realised I had no space just after I posted, but even then i can't get it to work