If you want to join two tables in same database

If the Order By clause needs to be changed

If you want to join two tables on different Oracle databases

If you want to join table and flat file