sql server mseq: want to see duplicates INNER JOIN -- sql server mseq

want to see duplicates INNER JOIN

AshleyT
4/21/2004 6:06:03 AM

sql server mseq: 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.Quantit
FROM dbo.tblItemOrder INNER JOI
dbo.cp_IV00101 ON dbo.tblItemOrder.Itemnumber = dbo.cp_IV00101.ITEMNMB
WHERE (dbo.tblItemOrder.Itemstatus = 'okay' and store = '001SS'
GROUP BY dbo.tblItemOrder.Itemnumber, dbo.tblItemOrder.Quantity, dbo.cp_IV00101.ITEMDESC, dbo.cp_IV00101.SELNGUO
ORDER BY dbo.tblItemOrder.Itemnumbe

Re: want to see duplicates INNER JOIN

Steve Kass
4/21/2004 1:48:12 PM

Please provide more information. It's impossible to see what duplicate
rows you are talking about without a better idea of what your tables and
data are. Can you give CREATE TABLE statements and sample data, then
show what you want to see as a result? Perhaps the problem is with
GROUP BY, though - how do you expect to see duplicate rows in a result
when you have asked for one row for each group by including GROUP BY?

SK

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.