Grammar is essentially a Delete from the from a ClassA a inner join (select * from ClassB) b on Anderson, D=b.I D and a.N ame=b.N ame, this statement can be deleted according to the ID and the Name ClassB ClassA table data,

ClassA is double primary key (ID, Name)
This statement in the Sqlite does not support, a great god to guide a solution, thank you

CodePudding user response:

 delete from ClassA 
The where (ID, Name) in (select ID, Name from ClassB); 

By the way, send you a SQLite learning resources,

CodePudding user response:

The

1/f, reference Dong Xuyang TonyDong response:

 delete from ClassA 
The where (ID, Name) in (select ID, Name from ClassB); 

By the way, send you a SQLite summary ,

hello, I tried it on, not line, an error near ", ": syntax error

CodePudding user response:

Delete t_szfqc from t_szfqc INNER JOIN t_szfqc_sorting on t_szfqc. Partno.=t_szfqc_sorting partno where t_szfqc. Quantity='3000'
My database executable, you transform your tables and fields