Tag : .NET, Win (Windows App), VB.NET, VS 2010 (.NET 4.x), Windows
Date :
2016-09-13 22:29:06
By :
jameavc
View :
772
Reply :
2
No. 1
Guest
Code (SQL)
UPDATE Rent
SET Rent.ReStatus = 'คีนครบ'
WHERE Rent.RenID = '0001' AND NOT EXISTS (SELECT 123 FROM RenDetail
WHERE RenDetail.RenID = '0001' AND LTRIM(RTRIM(RenDetail.Status)) = 'ยืม')