SQL delete data - delete a row of data-CodePudding

delete customer Yang ting,
DELETE the Customer
FROM the Customer, proout
WHERE the customer. CusNo=proout. CusNo and
CusName='Yang ting'
GO
Select * from Customer
Go
How to solve this conflict

CodePudding user response:

 
The delete b 
The from dbo. Customer t 
The join dbo. ProOut b 
On tc usNo=biggest usNo 
Where tc usName='Yang ting' 

The delete t 
The from dbo. Customer t 
Where tc usName='Yang ting'

CodePudding user response:

Is that two kinds of writing t=customer b=dbo. Proout??

CodePudding user response:

"T" and "b", respectively is dbo. The Customer table and dbo ProOut table .