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!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
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 ответов
+ 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