I tried running this script, but i kept getting not a group by error
-3
votes
1
answer
51
views
select
a.*,
b.Start_Date,
b.End_date,
sum(b.cost) as total_Cost
from Ess.TZeewrld a
left join Ess.Wrldest b
on a.account_number, = b.account_number,
group by
b.Start_Date,
b.End_date;
Asked by Super Dad
(1 rep)
Oct 15, 2021, 05:00 PM
Last activity: Oct 16, 2021, 08:43 PM
Last activity: Oct 16, 2021, 08:43 PM