Community Member Profile
Justin
Member since Sep 20, 2010
- Profile: /members/6899-Justin.htm
- Comments: 1
- Points: 12
Recent Blog Comments By Justin
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Sep 20, 2010 at 1:58 PM
Need help: UPDATE Test SET Debt = Debt + SalesRecord.Debt WHERE EXISTS (select * from SalesRecord where Test.Customer_Name = SalesRecord.Customer_Name AND Test.Debt>2000); Error:The multi-part identifier "SalesRecord.Debt" could not be bound.... read more »
