Tuesday, November 11, 2014
Extract data from selected columns from a list of tables. And there seems common columns for b.w table 1 and 2, similar b/w table 2 and 3 ...like this way(common alternate tables) ---Open
-- I could use join
/*select * from table1 join table2 On table1.column_name1 = table2.column_name1*/
This will list down the records(with same data in column_name1) for all columns in table1 and table2
What if you have situation for multiple tables..
/*select * from table1 join table2 On table1.column_name1 = table2.column_name1*/
This will list down the records(with same data in column_name1) for all columns in table1 and table2
What if you have situation for multiple tables..
Subscribe to:
Comments (Atom)