I have a table with two fields to hold qty values. Qty In Stock and Qty Out. I want to subtract the qty out from the qty in to determine qty available. The SQL db is accessed through a Win Form. The issue is I want the SQL command to recognize the qty in & qty out of currently selected item.