"Latest Transaction ID by Inventory Number"."Inventory Number" LIKE '%' || :Enter_Inventory_Number || '%'
SELECT "Latest Transaction ID by Inventory Number"."Inventory Number", "Chairs"."Manufacturer", "Chairs"."Name", "Chairs"."Model Number", "Chairs"."Textile Name", "Chairs"."Textile Color", "Chairs"."Wood Finish", "Chairs"."Metal Finish", "Chairs"."Shell Color", "Chairs"."Notes", "Log"."Location", "Log"."Date", "Log"."Contact Name", "Log"."Contact Phone", "Log"."Requested By", "Log"."Authorized By" FROM "Log", "Chairs", "Latest Transaction ID by Inventory Number" WHERE "Log"."Inventory Number" = "Chairs"."Inventory Number" AND "Latest Transaction ID by Inventory Number"."maxid" = "Log"."ID" GROUP BY "Latest Transaction ID by Inventory Number"."Inventory Number", "Chairs"."Manufacturer", "Chairs"."Name", "Chairs"."Model Number", "Chairs"."Textile Name", "Chairs"."Textile Color", "Chairs"."Wood Finish", "Chairs"."Metal Finish", "Chairs"."Shell Color", "Chairs"."Notes", "Log"."Location", "Log"."Date", "Log"."Contact Name", "Log"."Contact Phone", "Log"."Requested By", "Log"."Authorized By" HAVING ( ( "Latest Transaction ID by Inventory Number"."Inventory Number" LIKE '%' || :Enter_Inventory_Number || '%' ) )
SELECT "Chairs"."Inventory Number", MAX( "Log"."ID" ) AS "maxid" FROM "Log", "Chairs" WHERE "Log"."Inventory Number" = "Chairs"."Inventory Number" GROUP BY "Chairs"."Inventory Number"
Users browsing this forum: RPG and 20 guests