select table1.column,table2.column from table1,table2 where table1.column=table2.column(+);