Finds deceased animals between a date range.
See Create Export to CSV using SQL Query for information on using query below for export to csv.
See Create Export to CSV using SQL Query for information on using query below for export to csv.
select AM."Ref_Number" "Anm Num", AM."Name" "Anm Name", AM."Date_Died", AM."Date_Birth", CM."First_Name", CM."Last_Name", CM."Ref_Number" "Cln _Num" from "Animal_Main" AM
join "Client_Main" CM on CM."Ref_Number" = AM."Owner"
where AM."Date_Died" between :DateLo/*From*/ and :Datehi/*To*/
