select DM."Date", DM."Start", DM."Finish", DP."Dry_Name", SM."Id" as "Staff", DM."Notes", DM."Cln_Num", CM."First_Name", CM."Last_Name", DM."Sub_Num", AM."Name" as "Patient" from "Diary_Main" DM join "Client_Main" CM on CM."Ref_Number" = DM."Cln_Num" join "Animal_Main" AM on AM."Ref_Number" = DM."Sub_Num" join "Diary_Profile" DP on DP."Dry_Number" = DM."Dry_Num" join "Staff_Main" SM on SM."Ref_Number" = DM."Stf_Num" where DM."Ref_Number" = 100000?????