query="SELECT Product.*, News.*, Download.* FROM Product, News, Download where (Product.Title like '%"&keywords&"%')or (News.Title like '%"&keywords&"%') or (Download.Title like '%"&keywords&"%')"
小弟谢的有错吗? 怎么查询不出来啊?三张表一起搜索。
...全文
837打赏收藏
多表查询问题。请帮忙
query="SELECT Product.*, News.*, Download.* FROM Product, News, Download where (Product.Title like '%"&keywords&"%')or (News.Title like '%"&keywords&"%') or (Download.Title like '%"&keywords&"%')" 小弟谢的有错吗? 怎么查询不出来啊?三张表一起搜索。
SELECT id,title from Product where title like '%"&keywords&"%' union SELECT id,title from News where title like '%"&keywords&"%' union SELECT id,title from Download where title like '%"&keywords&"%'