select top 10 G_useradmin,G_webname
from [G_user]
where G_useradmin in(select distinct top 10 G_lbkj
from [G_user]
order by G_comeintime desc
) order by G_comeintime desc
错误一:子查询里面不能用order by
错误二:子查询 返回类型和与他比较的类型必须相同。
from [G_user]
where G_useradmin in(select distinct top 10 G_lbkj
from [G_user]
order by G_comeintime desc
) order by G_comeintime desc
错误一:子查询里面不能用order by
错误二:子查询 返回类型和与他比较的类型必须相同。
qianjin036a 您好,我按您的语句提示如下错误:
Microsoft JET Database Engine 错误 '80040e21'
子查询 'G_lbkj' 中 Memo 或 OLE 对象无效.希望高手们能帮我解决,谢谢,呵呵