这个sql如何关联2张表
- WBOY原创
- 2016-06-23 14:05:31893浏览
原sql语句为：
SELECT * from ( SELECT DISTINCT *, year( from_unixtime(time ) ) year, month( from_unixtime(time ) ) month FROM A表 WHERE id = 1) as a WHERE is_del =0 AND year = 1 AND month = 1 order by time DESC
现在我想关联B表.如何查询？
A表.id=B表.id
回复讨论(解决方案)
SELECT * from ( SELECT DISTINCT *, year( from_unixtime(time ) ) year, month( from_unixtime(time ) ) month FROM A表 WHERE id = 1) as a , B表 b WHERE a.id=b.ai and is_del =0 AND year = 1 AND month = 1 order by time DESC
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn