There are SQL sentences for layered quries
Qry1
SELECT QOD_OrdLog.ODID, QOD_OrdLog.ODPK, QOD_OrdLog.PDate, QOD_OrdLog.Kitchen, QOD_OrdLog.Job_Order, QOD_OrdLog.TDPK, QOD_OrdLog.ERP_Code AS FP_ERP_Code, QOD_OrdLog.Item_Eng AS FP_Eng_Name, QOD_OrdLog.Item_Arb AS FP_Arb_Name, QFP_RecPHIP.Unit_Arb...