Query Help

[MickDub]

i have follwoing table showing part number M1 with 5 entries
PONum PartNum
5331 M1
5331 M1
5332 M1
5332 M1
5332 M1

what i need help with is to be able to qrite a query that return that even though there are 5 entries for M1 that it is only on two seperate PoNum's

Part Num PoNum Count
M1 2 '(showings it is on 2 Different PoNumbers)

 

[lespaul]

SELECT PartNum, COUNT(PONum) FROM TableName GROUP BY PartNum

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[coco86]

Try

select temp1.partnum, count(temp1.PONum) as PoNumbCount from [select distinct partnum, ponum from tablename] as temp1 group by temp1.partnum

Or, use two queries

Query1
select distinct partnum, ponum from tablename

Query2
select partnum, count(PONum) as PoNumbCount from query1 group by partnum

-Coco