select A.a1, count(*) from A,B where A.a1 = B.b2 group by A.a1
union
select A.a1, count(*) from A,C where A.a1 = C.c3 group by A.a1
union
select A.a1, count(*) from A,C where A.a1 = C.c3 group by A.a1
解决方案 »
- mysql 存储过程 如何获得具体异常
- mysql出错,是不支持UTF-8吗?
- 建立mysql集群时,选择簇,还是heartbeat的方式?谁能帮忙介绍一下两种到底用在什么情况中吗?
- 请教 关于mysql性能测试
- Mysql 板块 报名
- postgresql 中有没有类似sqlserver中 #table1 或declare @table1 table(id int,age int);的语法
- 向mysql 插入记录的 疑惑
- 怎样 将access 2000 数据库中的表的数据导入PostgreSQL中相应的表
- 请问MySQL的varchar,最大长度是多少?
- 急!请教各位高手:请问mysql中如何将varchar类型转换成integer类型?
- 求教:mysql安装后问题
- 在线等:phpAds的问题:
use temp table or multiple mysql statements..
the solution without using "union" some months ago.
my model was even complicate then yours because single
temp table is not enough. therefore i have to create
a permanent "temp" table to replace the function of
union. so, i assume there are no other ways..