sql error: Table 'redblethbridge.rets_property_resi' doesn't exist SELECT SUM(cnt) AS thits FROM (SELECT COUNT(*) AS cnt FROM redblethbridge.rets_property_resi WHERE ( (ListOfficeMLSID='ldcentre') OR (ListOfficeMLSID='ldcentre2') OR (ListOfficeMLSID='ldcentre3') OR (ListOfficeMLSID='ldcentre4') OR (ListOfficeMLSID='ldcentre5') ) UNION SELECT COUNT(*) AS cnt FROM redblethbridge.rets_property_mult WHERE ( (ListOfficeMLSID='ldcentre') OR (ListOfficeMLSID='ldcentre2') OR (ListOfficeMLSID='ldcentre3') OR (ListOfficeMLSID='ldcentre4') OR (ListOfficeMLSID='ldcentre5') ) UNION SELECT COUNT(*) AS cnt FROM redblethbridge.rets_property_farm WHERE ( (ListOfficeMLSID='ldcentre') OR (ListOfficeMLSID='ldcentre2') OR (ListOfficeMLSID='ldcentre3') OR (ListOfficeMLSID='ldcentre4') OR (ListOfficeMLSID='ldcentre5') ) UNION SELECT COUNT(*) AS cnt FROM redblethbridge.rets_property_comm WHERE ( (ListOfficeMLSID='ldcentre') OR (ListOfficeMLSID='ldcentre2') OR (ListOfficeMLSID='ldcentre3') OR (ListOfficeMLSID='ldcentre4') OR (ListOfficeMLSID='ldcentre5') ) ) a