Hi All
I have following two tables
Table 1
=======
T1Col1 T1Col2 T1Col3
jkl nnn qoq
efg Aaa wow
efg xxx yoy
abc iii qoq
abc fff wow
abc rrr qoq
gdg ppp yoy
Table 2
=======
T2Col1 T2Col2
qoq nnn
wow aaa
yoy xxx
Link column between two table is T1.T1Col3 and T2.T2Col1
Expected Results
================
T1Col1 T1Col2 T1Col3 T2Col2
jkl nnn qoq nnn
efg Aaa wow aaa
efg xxx yoy xxx
abc iii qoq nnn
abc fff wow aaa
abc rrr qoq nnn
gdg ppp yoy xxx
With join query I am getting multiple records. But I am after the above no of records ONLY. Because
In my real scenario Table 1 got more than million records. So ultimate result set records count is
huge which exceeds MS ACCESS limitation
Is this possible
Cheers
Shabar