mujian1986 发表于 2011-03-17 15:41

informix 9.4 子查询,欢迎拍砖

select t1.*,t2.*
from table(multiset(select first 10 tabid::int tabid,tabname from systables order by tabid)) t1,syscolumns t2
where t1.tabid = t2.tabid
页: [1]
查看完整版本: informix 9.4 子查询,欢迎拍砖