首页 > 解决方案 > 我对这个查询有疑问,它说“不是唯一的表/别名'ownertbl'”我该怎么办?

问题描述

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'

标签: mysql-error-1066

解决方案


推荐阅读