I am getting an ORA-00928: missing SELECT keyword error despite the fact that I am using select in my insert. Anybody know what’s going on here?

insert into bi4618_09_free_time (‘rental_agreement_id’,’extension_free_time_amount’,’other_free_time_amount’,’promo_free_time_amount’,’delivery_free_time_amount’,’return_free_time_amount’,’extension_free_time_days’,’other_free_time_days’,’promo_free_time_days’,’delivery_free_time_days’)

select
rac.rental_agreement_id
,nvl(aph.retension_extension_amount,0) + nvl(aph.club_claim_extension_amount,0) + nvl(aph.service_extension_amount,0) as extension_free_time_amount
,case when nvl(aph.initial_payment,0) = 0 then nvl(aph.free_time_amount,0) else 0 end as other_free_time_amount
,case when nvl(aph.initial_payment,0) = 1 and sap.rental_agreement_id is not null then nvl(aph.free_time_amount,0) + sap.discount else 0 end as promo_free_time_amount
,case when nvl(aph.initial_payment,0) = 1 and sap.rental_agreement_id is null then nvl(aph.free_time_amount,0) else 0 end as delivery_free_time_amount
,nvl(pa.account_balance,0) as return_free_time_amount — This is the amount of uncollected money due to FREE TIME a borrower still has due when the store picks up the rented furniture. It is a hit on the store.
,nvl(aph.retension_extension_days,0) + nvl(aph.club_claim_extension_days,0) + nvl(aph.service_extension_days,0) as extension_free_time_days
,case when nvl(aph.initial_payment,0) = 0 then nvl(aph.number_of_days_free,0) else 0 end as other_free_time_days
,case when nvl(aph.initial_payment,0) = 1 and sap.rental_agreement_id is not null then nvl(aph.number_of_days_free,0) else 0 end as promo_free_time_days
,case when nvl(aph.initial_payment,0) = 1 and sap.rental_agreement_id is null then nvl(aph.number_of_days_free,0) else 0 end as delivery_free_time_days
from
bi4618_03_flags f — select * from bi4618_03_flags where rownum < 99;
left join zeus.rental_agreement_current rac — select * from zeus.rental_agreement_current where rownum < 99;
left join zeus.agreement_payment_history aph on rac.rental_agreement_id = aph.rental_agreement_id — select * from zeus.agreement_payment_history where rownum < 99; — select rental_agreement_id, count() from zeus.agreement_payment_history group by rental_agreement_id having count() > 1
left join zeus.sims_agreement_promotion sap on rac.rental_agreement_id = sap.rental_agreement_id — select * from zeus.sims_agreement_promotion where rownum < 99;
left join zeus.party_account pa on pa.account_type_id = 9999100000614 /This account_type_id is BACK_RENT (AKA RETURN_FREE_TIME)/ and rac.inactive_date is not null and rac.rental_agreement_id = pa.rental_agreement_id; — select * from zeus.party_account where account_balance > 0 and rownum < 99;
commit;

This insert should have worked. The columns match up, and it’s very similar to queries I have already run for this project. No idea what’s going on.