How to join two tables without using the Joiner Transformation.

Itz possible to join the two or more tables by using source qualifier.But provided the tables should have
relationship.
When u drag n drop the tables u 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 u will find EDIT click on it.Click on the properties tab,u will find sql query in that u can write ursqls
You can also do it using
Session --- mapping---source--- there you have an option called User Defined Join there you can write
your SQL