SELECT schools.id, schools.name, schools.cactus_name, schools.cactus_name_english, schools.address1, schools.address2, schools.city, schools.county, schools.postcode, schools.country, schools.active, schools.latitude, schools.longitude, schools.contact, schools.website, schools.email, schools.telephone, schools.fax, schools.dos, schools.other_contacts, schools.school_commission, schools.bo_notes, courses.name, courses.domains, courses.active, courses.course_type_id, course_types.course_type_id, course_types.name_en
FROM schools
INNER JOIN courses ON courses.school_id = schools.id
INNER JOIN course_types ON courses.course_type_id = course_types.course_type_id
WHERE courses.domains
IN (
'[CL]'
)
AND courses.active = 'Y'
AND schools.active = '0'
GROUP BY schools.id

UPDATE courses
SET courses.active = 'N'
FROM schools
INNER JOIN courses ON courses.school_id = schools.id
INNER JOIN course_types ON courses.course_type_id = course_types.course_type_id
WHERE courses.domains
IN (
'[CL]'
)
AND courses.active = 'Y'
AND schools.active = '0'

quote:

---

Originally posted by jarv

... check the manual that corresponds to your MySQL server version ...

---

quote:

---

Originally posted by jarv

hmm really?

---

quote:

---

Originally posted by jarv

hmm really?

---