select name ,surname,available_amount,
when name=credit_account then amount = amount+available_amount else amount end as available_balance from accounts_table,transaction_table;
我有一个存储过程和EXEC调用,如: @ScheduleID = (SELECT ScheduleID FROM ScheduleResourceID = (SELECT Vendor_ID FROM tblVendors WHERE Vendor_Name = 'Blue Line Taxi')“(”)<em