Chinaunix's Archiver
论坛
›
Informix
› informix 9.4 子查询,欢迎拍砖
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 子查询,欢迎拍砖