|
|
Posted by @sh on 02/27/06 16:54
Thanks to you both for your replies, I did actually try the Group By but
received the 'Aggregate function' error message that I couldn't quite
interpret into English....!!!
Many thanks, I'll give those a go - in the meantime I actually used this in
the end...
SELECT DeliveryID, Address, Organisation, Organisation, Town, County,
PostCode FROM SOL_Delivery WHERE DeliveryID IN (SELECT DISTINCT
REPLACE(Postcode,' ','') FROM sol_delivery WHERE CID = CID (ASP Variable)
ORDER BY Address DESC
....but I'll replace with your variants if you think the above is less
efficient?
Cheers, Ash
Navigation:
[Reply to this message]
|