解决方案 »
- 问个select
- 如何把 .sql 文件导入到 MySql 数据库中啊?请高手们指导一下
- 求通过链接服务器调用MYSQL上过程
- Postgresql存储过程问题(关于变量表名)
- mysql的启动问题
- mysqlcc显示中文乱码问题,并不是mysql原因,高分求救!
- Mysql相对于sqlserver的Trans..Sql由那些功能局限
- 怎么增加一个字段在表的最前面?急!!!!
- mysql单表怎么合并多列多行数据
- Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@
- You have an error in your SQL syntax; check the manual that corresponds to your
- 求牛牛们给条效率高的sql语句,或者........
inner join 表A b
on a.id=b.id;
inner join 表A b
on a.id=b.id and a.id=5 and b.id=6;
如果多次查询的话,是不是就像这种写法,请指点
select a.id from
(
(a a inner join a b) inner join a c
)
inner join a don
a.id=b.id and
a.id=c.id and
a.id=d.id and
a.aid=5 and b.aid=6 and c.aid=7 and d.aid=8;
select a.id from
a a inner join a b on a.id=b.id
inner join a c a.id=c.id
inner join a d a.id=d.id
where a.aid=5 and b.aid=6 and c.aid=7 and d.aid=8;