Example.sql

Alter Table S104 (Add CAB Logical, KST Logical, PLT Logical)

select * from S104 where Adoption_Date <> "" into qNoBlank
select * from qNoBlank where Adoption_Date < CurDate() into qCAB
select * from qNoBlank where Adoption_Date >= CurDate() into qKST1

select * from S104 where Adoption_Date = "" into qBlank
select * from qBlank where Date_Confirmation < CurDate() or dwellings(DWF_Total_m3_per_sec) < 50 into qKST2
select * from qBlank where Date_Confirmation > CurDate() and dwellings(DWF_Total_m3_per_sec) >= 50 into qPLT

update S104 set CAB = 0, KST = 0, PLT = 0

update qCAB set CAB = 1,  KST = 1, PLT = 1
update qKST1 set KST = 1, PLT = 1
update qKST2 set KST = 1, PLT = 1
update qPLT set PLT = 1