Help with SQL refrencing fields in same record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Instead of rewriting... please refer to the following link at another board...
http://forums.asp.net/t/1421011.aspx

My original select statement is...

SelectCommand="SELECT DISTINCT swinventory.catID, swsubcategory.subcatName,
swinventory.subcatID FROM (swsubcategory INNER JOIN swinventory ON
swsubcategory.subcatID = swinventory.subcatID) WHERE (swinventory.subcatID =
?) ORDER BY swsubcategory.subcatName">

<SelectParameters>

<asp:QueryStringParameter DefaultValue="?" Name="subcatID"
QueryStringField="subcatid" Type="Int32" />

</SelectParameters>


I need to somehow reference the catID and the subcatID at the same time.

The subcatID is need in the link query to push user to another page and
display all items that = sucatID.

The catID is needed to display all the subcatID menu items that are clicked
to display items mentioned above.

I am displaying products from subcatID OK. The problem I am having is not
getting my menu items to display based on the catID that is in the same
record as the subcatID.

Please help.

Needed this solved yesterday. :-)

TRU
.

Relevant Pages