ถามเรื่อง การ select multi table เช่น (SELECT title FROM ks_activity WHERE title like'%teacher%' ) UNION

(SELECT title ,'activity' as source FROM 'ks_activity WHERE title like'%teacher%' ) UNION
(SELECT title ,'news' as source  FROM ks_news WHERE title like'%teacher%') UNION
(SELECT title ,'carendar' as source  FROM ks_carendar WHERE title like'%teacher%')
order by title like'%teacher%' 

SELECT * FORM user u, local l WHERE u.id=l.id