update accounts set balance = balance-purchased_amount where balance>=purchased_amount and credit_limit>=purchased_amount and expiry_date>today() and customer_id =provided_id and card_num = provided_cardnum select c.customer_id, a.card_num, a.expiry_date,a.credit_limit,a.balance from customers c left outer join accounts a on a.customer_id = c.customer_id and a.card_num = provided_cardnum where c.customer_id = provided_id