sales_mark_as_fullypaid.sql

use iframer;

update sale s set FullyPaid=1

where YEAR(s.Created) between 2012 and 2018 and s.FramerID = 'bea8ac99-04dd-48da-8db8-ba572bf8ffe2';



select * from sale s

where YEAR(s.Created) between 2012 and 2018 and s.FramerID = 'bea8ac99-04dd-48da-8db8-ba572bf8ffe2' and fullypaid=0;

updatejob_collected_completed.sql

use iframer;

update job as j 
inner join sale s
on j.SaleID = s.id
set j.Completed = 1, j.Collected = 1

where YEAR(s.Created) between 2018 and 2019 and s.FramerID = '';
/*where s.id = '21393bfc-24b6-430b-9119-23f0a434faab';*/



select * from job j 
inner join sale s
on j.SaleID = s.id

where YEAR(s.Created) between 2018 and 2019 and s.FramerID = 'bea8ac99-04dd-48da-8db8-ba572bf8ffe2';
/*where s.id = '21393bfc-24b6-430b-9119-23f0a434faab';*/