Comparing rows to columns
-
Hi, I have one table as, id Items 1 col1 2 col2 3 col3 another table as Sid col1 col2 col3 col4 1 A B NULL NULL 2 D E NULL F now i have to compare Items of tbl1 with columns of tbl2. here i need the output as true or false from select query. for ex. col1 of tbl1 is compared with col1 of tbl2.if the col1 has value then it should return false. if all values are null then it should return as true. here im expecting col1-false,col2-false,col3-true
Nothing is Impossible. Keep always Smiling... :)
modified on Wednesday, May 5, 2010 5:39 AM
-
Hi, I have one table as, id Items 1 col1 2 col2 3 col3 another table as Sid col1 col2 col3 col4 1 A B NULL NULL 2 D E NULL F now i have to compare Items of tbl1 with columns of tbl2. here i need the output as true or false from select query. for ex. col1 of tbl1 is compared with col1 of tbl2.if the col1 has value then it should return false. if all values are null then it should return as true. here im expecting col1-false,col2-false,col3-true
Nothing is Impossible. Keep always Smiling... :)
modified on Wednesday, May 5, 2010 5:39 AM
What have you tried so far ?
My advice is free, and you may get what you paid for.