SQL Update CheckingAccount ?
Posted: Tue Jan 03, 2017 9:45 pm
These don't work, and I don't know why........ This is day Five on this.......
-------------------------------- A ---------------------------------------------------------------
UPDATE CHECKINGACCOUNT_V1
SET PAYEEID=30,
CATEGID=35,
SUBCATEGID=74
WHERE ACCOUNTID=2
And PAYEEID=335
And CATEGID=125
And TRANSAMOUNT=(995 or 987);
-------------------------------- B ---------------------------------------------------------------
UPDATE CHECKINGACCOUNT_V1
SET PAYEEID=30,
CATEGID=35,
SUBCATEGID=74
WHERE ACCOUNTID=2
And PAYEEID=335
And CATEGID=125
And (TRANSAMOUNT=995 or TRANSAMOUNT=997);
Please Help???????????????????
-------------------------------- A ---------------------------------------------------------------
UPDATE CHECKINGACCOUNT_V1
SET PAYEEID=30,
CATEGID=35,
SUBCATEGID=74
WHERE ACCOUNTID=2
And PAYEEID=335
And CATEGID=125
And TRANSAMOUNT=(995 or 987);
-------------------------------- B ---------------------------------------------------------------
UPDATE CHECKINGACCOUNT_V1
SET PAYEEID=30,
CATEGID=35,
SUBCATEGID=74
WHERE ACCOUNTID=2
And PAYEEID=335
And CATEGID=125
And (TRANSAMOUNT=995 or TRANSAMOUNT=997);
Please Help???????????????????