要查询三个表的编号 姓名 类型字段 但是三个表没有相关联不能使用join查询 所以使用union把单独查询出来的结果合成一个表
SELECT * FROM ( SELECT s.id as id , `service_title` AS name,'psm_service_center' as dbase, c.classify_name AS type FROM psm_service_center AS s, psm_classify AS c where 1=1 AND s.service_classify = c.id <if test="name != null"> AND service_title like CONCAT('%', #{name}, '%') </