finishing SQL Query using OR operator 1

[aonefun]

Here is the first portion of my query which works fine:

SELECT ManufacturerPartNumber, ProductFamily FROM Products WHERE ManufacturerPartNumber = Request.Form("ManufacturerPartNumber")

However, I need to add an OR operator to include additional ManufacturerPartNumbers that share a common ProductFamily as the ManufacturerPartNumber that matches exactly to the Request.Form

>How do I complete the query to accomplish this?

 

[PHV]

Something like this ?
SELECT ManufacturerPartNumber, ProductFamily
FROM Products
WHERE ProductFamily In (
SELECT ProductFamily FROM Products
WHERE ManufacturerPartNumber = Request.Form("ManufacturerPartNumber")
)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aonefun]

This seems right. I'm not sure why it's not working though. I'm wondering if this is because I'm setting a session variable to equal Recordset1.Fields.Item("ManufacturerPartNumber").Value

This is not SQL, wondering if you might know if a session variable can contain more than one value as can a recordset.