without using joiner transformation n sql override how can we join two tables

hi,

how can i join two tables (from same schema) without using joiner transformation and without using SQL override.

i tried using source qualifier transformation, but at one point i m gettin strucked that how will i join data from these table without using joining condition i.e without writing sql overridee.

Please help.

hi,
why dnt you try with lookup override in lookup t/f.

this will work.

reply me back if doesn't workout this

[QUOTE=neelkamal88;11974]hi,

how can i join two tables (from same schema) without using joiner transformation and without using SQL override.

i tried using source qualifier transformation, but at one point i m gettin strucked that how will i join data from these table without using joining condition i.e without writing sql overridee.

Please help.[/QUOTE]