Hi Claude
If you want quick and nasty without a second query you could try
select
tt.*, tcost.total
from
transaction_table tt,
(
select sum(cost)
from transaction_table
where transaction_month = 'December' /* Same as like with no % */
) as tcost
where
transa
Hi Claude,
This isn't syntactically best practice but if I understand your question do.
Select fieldnames (Select sum(cost) as total_cost
from transactions_table
where transaction_month like 'December') AS total_cost
from transactions_table
where transaction_month like 'December'
this way every