For my Asp .net project i'm using sql server 2008 database...for my project i need to get a particular output from my database.. My condition is..
Suppose there are 4 tables (Table1,Table2.Table3,Table4) in my DB.. each table contain 3 to 4 similar columns...(For eg:-column name A,B,C,D).. My condition is i want to get Column D value(data type int) from all tables in such a way tat if Table1 column D value is one i need to check Table2 D value or i dnt need to check next table values and i want to get tat Table1 column d value to my project.. ( we can use A, B,C as where condition cluse for our query)