0
DELETE ownertbl.*, motorcycletbl.*, transactiontbl.*  
from (ownertbl 
INNER JOIN motorcycletbl on ownertbl.plate_no = motorcycletbl.plate_no) 
INNER JOIN transactiontbl on motorcycletbl.plate_no = transactiontbl.plate_no , (ownertbl 
INNER JOIN motorcycletbl on ownertbl.body_no = motorcycletbl.body_no) INNER JOIN transactiontbl on motorcycletbl.body_no = transactiontbl.body_no 
WHERE ownertbl.plate_no = 'ABB1234' or ownertbl.body_no= 'T-0000'
Tanveer Badar
  • 5,438
  • 2
  • 27
  • 32
Vincent Jhon A. Lopez
  • 1
  • I also tried this query DELETE own.*, motor.*, trans.* from (ownertbl own INNER JOIN motorcycletbl motor on own.plate_no = motor.plate_no) INNER JOIN transactiontbl trans on motor.plate_no = trans.plate_no, (ownertbl own INNER JOIN motorcycletbl motor on own.body_no = motor.body_no) INNER JOIN transactiontbl trans on motor.body_no = trans.body_no WHERE own.plate_no = 'ABB1234' or own.body_no= 'T-0000' – Vincent Jhon A. Lopez Nov 19 '19 at 04:10
  • i tried giving them an alias but it still doesnt work – Vincent Jhon A. Lopez Nov 19 '19 at 04:11

0 Answers0