|
Posted by markc600 on 02/27/06 16:44
For the non-unique addresses, you will have a choice
of DeliveryIDs, which one do you want?
If you want just one of them, you can do this
SELECT MAX(DeliveryID), Address, Organisation, Organisation, Town,
County, PostCode
FROM SOL_Delivery
WHERE CustomerID = 15
GROUP BY Address, Organisation, Organisation, Town,
County, PostCode
Navigation:
[Reply to this message]
|