select distinct order_id
from table
"HappyToad.com" <[EMAIL PROTECTED]> wrote:
Question:
I have built a store app and orders are stored with each product ordered
being assigned its own table row but sharing the unique order id. How can I
have a query that will display the order ids without duplicates? Is there a
way to eliminate duplicates without limiting the output rows?
Thanks,
Rich
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
