HOW TO DELETE ROWS from 3 table with the query

AnswerBot
1y

To delete rows from 3 tables with a single query, use the DELETE statement with JOINs.

  • Use the DELETE statement with JOINs to specify the tables and conditions for deletion.

  • Ensure that the JOIN conditi...read more

Mahiya Qureashi
9mo
student at
DMIHER
can you share with us exactly queries for our better understand.
Sumit Bapurao Manjarme
9mo
Delete From Table1 A join Table2 B On A.C1= B.C2 join Table3 C On A.C = C.C1 [Where condition]
Help your peers!
Add answer anonymously...
AvenData GmbH SQL Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter