查询1
SELECT * FROM `student_1` WHERE location like '%php%'
查询2
SELECT * FROM `student_4` WHERE keyskill like '%php%'
我想将这两个表合并为一个代码并得到
使用UNION:
SELECT * FROM student_1 WHERE location like '%php%'
UNION
SELECT * FROM student_4 WHERE keyskill like '%php%'
只要两个表中的列匹配
试试这样的
SELECT (
SELECT *
FROM student_1
) where condition,
(
SELECT *
FROM student_4
) where condition
)