HI I Have 4 tables all relating to orders. Master, detail, status, and a log. the log is very key for the application. I would like to see how I am going to access the records with a status of ACTIVE.
what all your table contains? without understanding that its quite difficult to give a suggestion. post some sample data from tables and then explain what you want giving required output
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
1) Create a new view. 2) Add the tables master, detail, status and log. 3) In the where clause, specifiy status = 'Active' 4) Run the view or copy the SQL that is produced.
OK should have said i am in new job. so i was trying to understand some of the tables i have to use for an app. it turns out i only need one table actually so i am good to go.
How to get the tables or database schema
Posted - 08/30/2011 : 08:35:50
