EMagine Echuca Moama on the banks of the Mighty Murray River!
Select QCA.*, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Amenities)), ''), QCA.Amenities) as Amenities, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Directions)), ''), QCA.Directions) as Directions, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Description)), ''), QCA.Description) as Description, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Special)), ''), QCA.Special) as Special from qrycustomersall QCA LEFT JOIN (SELECT CO.* FROM CustomerOverrides CO WITH(NOLOCK) INNER JOIN ControlModule CM WITH(NOLOCK) ON CO.ControlId = CM.Control_Id WHERE (CM.ModuleId = 94)) Overrides ON (68 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 0 and ( QCA.control_id = 68 ) and QCA.show = 1
The specified operator could not be found. Please go back and try again.