660:
SQL: SELECT MasterDevelopments.MasterDevelopmentName, Developments.DevelopmentName, Properties.PropertyName, MasterDevelopments.MasterDevelopmentID, Developments.DevelopmentID, Properties.PropertyID FROM MasterDevelopments LEFT OUTER JOIN Developments ON (MasterDevelopments.MasterDevelopmentID LIKE Developments.MasterDevelopmentID) LEFT OUTER JOIN Properties ON (Developments.DevelopmentID LIKE Properties.DevelopmentID) WHERE ((MasterDevelopments.IsLive NOT LIKE 0)) ORDER BY MasterDevelopments.MasterDevelopmentName ASC, Developments.DevelopmentName ASC, MasterDevelopments.MasterDevelopmentName, Developments.DevelopmentName, Properties.PropertyName