To insert data..

Hi,

I have a new query, suppose i have three tables. Now the first two tables T1 & T2 have some common data…

Now what i have to do is that all the uncommon matched data from T1 & T2 will moved to Table T3…and it will be shown in table T3…but this all we have to do without using any LOOP…

Plz, have some suggestions.

Pranav Gupta

No loops? Recursion is allowed? [:)]

Seriously, use insert_recordset with notexists join, if it covers your particular needs.

Ohk…but plz tell me in detail…

I don’t know details of your case. If you want an example how to use insert_recordset with a join, just follow the link I found for you.

If you have any specific question, feel free to ask, but “plz tell me in detail…” is not specific enough.

Thanks Martin…

I have solved my problem…