$gjc=$_POST[gjc];
$sql="select * from (select * from xsktdl union all select * from xsktdl2) where text1 like '%$gjc%'";

2个表都有相同字段 text1

gjc是提交过来的值

查询单个表可以查询到结果