mapping non related columns in where condition
Posted: Mon Nov 19, 2007 10:56 pm
Hi,
I have code like this:
select col1 from tbl1 where tbl1.col2=tbl2.col2 and tbl2.col1=tbl3.col1.
I can create hash file for tbl2.col2 and map with the source table col but how can I map the second where condition because it doesn't have source table in the condition, two tables are different from source table.
thanks in advance.
I have code like this:
select col1 from tbl1 where tbl1.col2=tbl2.col2 and tbl2.col1=tbl3.col1.
I can create hash file for tbl2.col2 and map with the source table col but how can I map the second where condition because it doesn't have source table in the condition, two tables are different from source table.
thanks in advance.