sql for producing same product_name with unique product_id. 1

[qyllr]

querying against a product table. what's the best way to produce an output with all the records that have the same product_name but have different product_id_number's? product_id_number is the primary key for the product table. i am trying to just collect all the product_id_number's from the query.

 

[Tim1]

Hiya,

The query that you want is

SELECT a.product_id_number,
a.product_name
FROM table a
WHERE a.product_id_number IN (SELECT b.product_id_number
FROM table b
WHERE b.product_name = 'whatever')

Tim

 

[qyllr]

hi,

this is not working...do you have any other suggestions?

thanks...

 

[qyllr]

Thanks for the jump start...I decided to use a self join and != in my where clause and that worked.

q.