sql query to add records that share a common productfamilyid

[aonefun]

Some products in my database named "ManufacturerPartNumber" are part of a product family, thus they share a common "ProductFamilyID".
How do I include these additional "ManufacturerPartNumber" fields that share a common ProductFamilyID in the query as follows:

SELECT ManufacturerPartNumber, ProductFamilyID
FROM Products
WHERE ManufacturerPartNumber = Request.Form("VendorPartNumber")OR
ManufacturerParNumber [this is where I am stuck]

 

[mrdenny]

If I'm reading your requirements correctly then a subquery should do the trick.

SELECT Products.ManufacturerPartNumber, Products.ProductFamilyID
FROM Products
WHERE ManufacturerPartNumber = Request.Form("VendorPartNumber")
   OR ProductFamilyId IN (SELECT ProductFamilyID FROM Products WHERE WHERE ManufacturerPartNumber = Request.Form("VendorPartNumber"))

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[aonefun]

thank you for your response. Can you please phrase this portion of the query in psuedocode (plain english)

"OR ProductFamilyId IN"