want to see duplicates INNER JOIN
From: AshleyT (anonymous_at_discussions.microsoft.com)
Date: 04/21/04
- Next message: larry: "Time Out Error"
- Previous message: karendavis_at_optonline.net: "My new nipple and vagina piercings"
- Next in thread: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Reply: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 06:06:03 -0700
Below is my query where I want to see duplicate rows, but I don't:
SELECT dbo.tblItemOrder.Itemnumber, dbo.cp_IV00101.ITEMDESC, dbo.tblItemOrder.Quantity
FROM dbo.tblItemOrder INNER JOIN
dbo.cp_IV00101 ON dbo.tblItemOrder.Itemnumber = dbo.cp_IV00101.ITEMNMBR
WHERE (dbo.tblItemOrder.Itemstatus = 'okay' and store = '001SS'
GROUP BY dbo.tblItemOrder.Itemnumber, dbo.tblItemOrder.Quantity, dbo.cp_IV00101.ITEMDESC, dbo.cp_IV00101.SELNGUOM
ORDER BY dbo.tblItemOrder.Itemnumber
how can I see those rows as duplicates? It is a working table that I don't have a primary key in, and was hoping not to have to add one. Thanks for any ideas.
- Next message: larry: "Time Out Error"
- Previous message: karendavis_at_optonline.net: "My new nipple and vagina piercings"
- Next in thread: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Reply: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Messages sorted by: [ date ] [ thread ]