Every derived table must have its own alias
这个是SQLSELECT comusername,comuserid,saytext,saytime,writername,writerid FROM (SELECT a.username as comusername,a.userid as comuserid,a.saytext,a.saytime,b.username as writername,b.userid as writerid FROM ***_enewspl a left join ***_ecms_blog b on a.id=b.id WHERE 1 AND b.classid=26) union all (SELECT a.username as comusername,a.userid as comuserid,a.saytext,b.username as writername,b.userid as writerid FROM ***_enewspl a left join ***_ecms_photo b on a.id=b.id WHERE 1 AND b.classid=37) LIMIT 8
这个是SQLSELECT comusername,comuserid,saytext,saytime,writername,writerid FROM (SELECT a.username as comusername,a.userid as comuserid,a.saytext,a.saytime,b.username as writername,b.userid as writerid FROM ***_enewspl a left join ***_ecms_blog b on a.id=b.id WHERE 1 AND b.classid=26) union all (SELECT a.username as comusername,a.userid as comuserid,a.saytext,b.username as writername,b.userid as writerid FROM ***_enewspl a left join ***_ecms_photo b on a.id=b.id WHERE 1 AND b.classid=37) LIMIT 8
解决方案 »
- MYSQL函数无法运行,找不出错误.
- 請教Postgresql使用check檢查唯一性,請大家幫幫忙
- 如何对mysql5.0中的boolean字段附值?
- 关于linux下直接拷贝myisam类型表备份的问题!!急~~~~~
- MYSQL用JDBC插入数据,部分数据乱码
- mysql的嵌套的查询语句有什么特殊的语法要求吗,这个为什么不对?
- 如何在w2k下如何增加mysql的最大连接数?
- 为什么mysql里面无法输入中文?
- 如何在Select...From...Where內创建一个空列然后循环分配数个DATE
- ssh项目报错,连接不了数据库
- 求一条sql语句,关联3个表格查询
- mysql5 中一个数据表可以储存多少条数据量
left join ***_ecms_blog b on a.id=b.id WHERE 1 AND b.classid=26)
union all
(SELECT a.username as comusername,a.userid as comuserid,a.saytext,b.username as writername,b.userid as writerid FROM ***_enewspl a left join ***_ecms_photo b on a.id=b.id WHERE 1 AND b.classid=37) bb LIMIT 8
(SELECT a.username as comusername,a.userid as comuserid,a.saytext,a.saytime,b.username as writername,b.userid as writerid FROM
`***_enewspl` a
left join `***_ecms_blog` b on a.id=b.id WHERE 1 AND b.classid=26
union all
SELECT a.username as comusername,a.userid as comuserid,a.saytext,b.username as writername,b.userid as writerid FROM `***_enewspl` a left join `***_ecms_photo` b on a.id=b.id WHERE 1 AND b.classid=37)
bb LIMIT 8注意你的表名,修改一下