mr
Hi All,
I have a case where i need to pass data from Table X to table Z but before passing i need to do lookup on three column and they read three different table.
So column A needs to get value from Table A column B from Table B and Column c from table c.
I am confused which to use Lookup or join? they both will be left outer join.
Each table has good data like 20,000+ rows.and on one table i have to put 9 conditions like where a=sb=b.....
Which is more feasible and faster solution for me,
**