Delete a records

C

Christine Imbeault

Hi

I have two tables

table QE

iNoCritere cDescQE
1 question1
1 question2
2 question1
2 question2


table IC

iNoCritere cDescQE
1 C1
2 C2

I want Delete from Table IC and delete table QE where IC.inocritere =
QE.inocritere

DELETE CI.iNoCritere
FROM CI INNER JOIN CI ON QE.iNoCritere = CI.iNoCritere
WHERE (((QE.iNoCritere)=2));

My response is not correct. i want the response:

iNoCritere cDescQE
1 C1

iNoCritere cDescQE
1 question1
1 question2
 
Top