mubi_masti
10-19-2011, 12:34 AM
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)
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)