Its possible to join the TWO or more tables by using source qualifier. But provided the tables should have relationship.

When you drag and drop the tables you will getting the source qualifier for each table. DELETE all the source qualifiers. Add a common source qualifier for all. Right click on the source qualifier you will FIND EDIT click on it. Click on the properties tab, you will find sql QUERY in that you can write your sqls.

You can also do it using SESSION --- mapping---source there you have an option called User Defined Join there you can write your SQL.

Its possible to join the two or more tables by using source qualifier. But provided the tables should have relationship.

When you drag and drop the tables you will getting the source qualifier for each table. Delete all the source qualifiers. Add a common source qualifier for all. Right click on the source qualifier you will find EDIT click on it. Click on the properties tab, you will find sql query in that you can write your sqls.

You can also do it using Session --- mapping---source there you have an option called User Defined Join there you can write your SQL.