I must delete the ids of a table that are in common with the data of another table but I don't understand how | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

I must delete the ids of a table that are in common with the data of another table but I don't understand how

20th Mar 2021, 9:38 PM
kihhat
kihhat - avatar
2 Answers
+ 1
maybe somethinng like this would work. delete a from table1 as a inner join table2 as b on a.id = b.id;
20th Mar 2021, 11:22 PM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
What exactly did you mean by "IDs that are common with another table"?
21st Mar 2021, 4:06 AM
Ipang