Hey CELKO, .THANX A TON for that answer. That was exactly what i needed to know. I am working on sql server, and FYI about the question, it actually came...

Ashish thanks a ton for the reply.

My query is something like:

SELECT LT1.COL1, LT1.COL2, LT2.COL3, LT2.COL4, LT1.COL5, LT1.COL6

FROM LARGE_TABLE_1 LT1

JOIN LARGE_TABLE_2 LT2 ON LT1.C1 = LT2.COL1 AND LT1.COL2 = LT2.COL2

JOIN...

No replys. Does that mean the question is too easy to be asked on forum? Or am i not really clear with the question? Pls let me know.

Guys, i have...