Transfer data Query

[mubi_masti]

Hello

Can any one help me in developing a query

I have three tables, tblA, tblB, tblC

Tbl A has two fields, std and camp
While tbl B also has same to field ( it is temporary table)
tblC has one field camp

tbl A and and tbl C are linked with 1 to many relationship

I want to transfer data from tblB to tblA where

(tblB.std is not in tblA.std) but (tblB.camp of same std = tblC.camp)

After that

Delete all entries in tblB where


(tblB.std = tblA.std) and (tblB.camp = tblA.camp)