高手 这是怎么回事啊 ！！！

[haojielyb]

select distinct mytb.Fff,(select myta.fff from myta where Fid=1 limit 0,1) as ff1, (select myta.fff from myta where Fid=1 limit
1, 1) as ff3,(select myta.fff from myta where Fid=1 limit 2, 1) as f
f3 from mytb;


select distinct mytb.Fff,(select myta.fff from myta where Fid= mytb.f
id limit 0,1) as ff1, (select myta.fff from myta where Fid=mytb.fid limit
1, 1) as ff3,(select myta.fff from myta where Fid=mytb.fid limit 2, 1) as f
f3 from mytb;

两个语句相差之处 就是 把Mytb.id 换成了常量 就能执行了
我想让第二句 能执行该怎么修改

[haojielyb]

Subquery returns more than 1 row

错误提示
子查询多于一行
可是我不是用limit 限制了吗？

[haojielyb]

up

[haojielyb]

楼上 的语句在那里运行阿
oralce 中

一个语句中可以有多个limit吗？

[allright_flash]

select distinct mytb.Fff,(select myta.fff from myta,mytb where Fid= mytb.f
id limit 0,1) as ff1, (select myta.fff from myta,mytb where Fid=mytb.fid limit
1, 1) as ff3,(select myta.fff from myta,mytb where Fid=mytb.fid limit 2, 1) as f
f3 from mytb;

[小辉]

没有用过 MySql
不知道这样对不对
兄弟试试看吧

select distinct b.Fff , a1.fff as ff1 , a2.fff as ff2 , a3.ff as ff3
from mytb b
left outer join myta a1 on a1.Fid= b.fid limit 0,1
left outer join myta a2 on a2.Fid= b.fid limit 1,1
left outer join myta a3 on a3.Fid= b.fid limit 2,1

[haojielyb]

谢谢 allright_flash
您的可以成功但是有错误更改如下
select distinct mytb.Fff,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 0,1) as ff1, (select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 1,1) asff3,(select myta.fff from myta,mytb where myta.Fid=mytb.fid limit 2, 1) as ff3 from mytb;