Home > IT Answers > Development > Using answer as criteria in sql server
Jeremyj54
5 pts.
 Using answer as criteria in sql server
SQL, SQL Server
I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially I want to see a list of demand orders.

Software/Hardware used:
ASKED: October 7, 2008  3:11 AM
UPDATED: October 7, 2008  11:56 PM
RELATED QUESTIONS
Answer Wiki:
SELECT demand_order,supply_order FROM table_name WHERE demand_order = order#; table_name is the table demand_order is the name for the demand order column supply_order is the name for the supply order column order# is the order you want. You can use the same statement for supply orders too.
Last Wiki Answer Submitted:  October 7, 2008  9:42 pm  by  mshen   27,310 pts.
All Answer Wiki Contributors:  mshen   27,310 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Maybe you can show some example data, and the desired result of the query, in order to be sure your question is understood.

carlosdl
 63,535 pts.