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


帮我转成标准的语句撒
我 看不懂了
老大门帮一哈忙撒 THANKS

你写的这个语句好象有错误哟
第一层的查询语句没有 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 （表二）
从二张表中进行查询数据