SQL删除数据---删除某一行的数据

[还在学习的小白]

删除顾客杨婷的个人信息。
DELETE Customer
FROM Customer,proout
WHERE customer.CusNo=proout.CusNo and
CusName = '杨婷'
GO
select * from Customer
go
这个冲突怎么解决

[唐诗三百首]

delete b
 from dbo.Customer t
 join dbo.ProOut b
   on t.CusNo=b.CusNo
 where t.CusName='杨婷'

delete t
 from dbo.Customer t
 where t.CusName='杨婷'

[还在学习的小白]

是两种写法吗 t=customer b=dbo.proout？？

[唐诗三百首]

"t"和"b"分别是dbo.Customer表和dbo.ProOut表的别名.

[紫魂一号]

delete from customer where exists(select 1 from proout where proout.CusNo = customer.CusNo) and CustName = 'XX'