SELECT LabID FROM LabDef ORDER BY LabID SELECT AD.ID, AD.appCust, AD.Datatype, AD.DefaultValue, AD.Description, AD.Removed, AO.ID as overrideID, AO.appCust, AO.labID, AO.overrideValue FROM appCustDefaults AD LEFT JOIN (SELECT * FROM appCustOverrides WHERE LabID = ) AO ON AD.appCust = AO.appCust WHERE AD.Removed = 0 ORDER BY AD.AppCust, AO.ID desc, AD.ID, AO.appCust, AD.AppCust ASC