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..