ORACLE中的 SQL的语句 问题

你写的这个语句好象有错误哟
第一层的查询语句没有 from 好象!你自己再好象检查一下!我也不太懂!

Sql = "
select
*
from
(select
row_.*,rownum rownum_
from
(" &_ "select
t1.group_id,
t1.group_name,
t1.group_desc,
t2.real_name
from
icms_group t1,icms_user t2
" &_ "where
t2.user_id = t1.builder_id
order by
t1.group_id desc" & ")
row_where
rownum <= " & intEndRow & ")
where
rownum_ >= " & intStartRow

[此贴子已经被作者于2007-4-19 23:30:25编辑过]

是一个连接查询哟 group_id,
t1.group_name, (表一)
t1.group_desc,
t2.real_name （表二）
从二张表中进行查询数据