急求关于复合查询的解答

[lilei22]

select * from (select t1.*,t2.* rownum rid from t1,t2 where t1.id=t2.id and rownum<=10) where rid>=1;执行查询时报错：未明确定义列。改为select t1.*,t2.* from (select t1.*,t2.* rownum rid from t1,t2 where t1.id=t2.id and rownum<=10) where rid>=1;仍然报相同的错误，请问该如何解决？

[ORARichard]

t2.* rownum rid

你这里缺","

[ORARichard]

另外看不出楼主这句话写的目的。尤其是"where rid>1"

[liuyi8903]

呵呵.还是ORARichard(没钱的日子好难过啊)兄观察细致啊:)

[yxxx]

呵呵，少逗号了。

[jingling76]

select * from (select t1.*,t2.* ,rownum ,rid from t1,t2 where t1.id=t2.id and rownum<=10 and t1.rid>=1 and t2.rid>=1) ;