insert into auths select account_id, “authorization” from card_batch_items, customers
where card_batch_id = 61 and status = ‘Completed’
and card_batch_items.customer_id = customers.id
and “authorization” not in (select number from transactions where number is not null);
insert into transactions (number, date, memo)
select “authorization”, ‘2007-8-25’, ‘Credit Card Charge’ from auths;
insert into transaction_items (account_id, amount, transaction_id, number) select
case when alternation.i = 1 then account_id else 1552 end as account_id,
case when alternation.i = 0 then -amount else amount end as amount,
transactions.id as transaction_id,
auths.”authorization” as number
from card_batch_items, alternation, auths, transactions
where card_batch_id = 60 and card_batch_items.status = ‘Completed’
and auths.”authorization” = card_batch_items.”authorization”
and transactions.number = auths.”authorization”