要做一个站内搜索引擎,同时搜索两个表给出结果,我的代码如下:
(SELECT * FROM `#@__infoimg` WHERE title LIKE '%$keyword%' AND delstate='' AND checkinfo=true) UNION ALL (SELECT * FROM `#@__infolist` WHERE title LIKE '%$keyword%' AND delstate='' AND checkinfo=true) ORDER BY ID DESC
运行出现错误:union detect 请高人指点啊