Select meetings_table.*,vet_table.*,vet_alt_comp_table.*
FROM meetings_table,vet_table,vet_alt_comp_table
WHERE (meetings_table.meeting_type LIKE '%1%'
OR meetings_table.meeting_type LIKE '%3%')
AND meetings_table.meeting_id=vet_table.meeting_id
AND meetings_table.meeting_id=vet_alt_comp_table.meeting_id
AND ((vet_table.cardiology='Y' OR vet_table.surgery='Y')
OR (vet_alt_comp_table.homeopathy='Y' OR vet_alt_comp_table.tcm_acupuncture='Y'))
ORDER BY start_date