Re: want to see duplicates INNER JOIN

From: Steve Kass (skass_at_drew.edu)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 13:48:12 -0400

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

AshleyT wrote:

>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.
>
>

Relevant Pages