主题：[求助]查询表求助

.

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:查询表.foxdb

升级最新版本的开发版啊(不是2014测试版,2013-10-14版)

select *,(select Top 1 b.username from {system_users} b where a.fieldstr15=Cstr(b.id)) as username15, (select Top 1 c.username from {system_users} c where a.fieldstr16=Cstr(c.id)) as username16 from {workflow_file} a

select c.fileno,c.fieldstr15,c.fieldstr16,c.username15,d.username as username16 from (select *,b.username as username15 from {workflow_file} a inner join {system_users} b on Cint(a.fieldstr15)=b.id) c inner join {system_users} d on Cint(c.fieldstr16)=d.id

这个是手写的.

a b c d那只不过是别名而已. 这个没办法三言两语解释清楚,有兴趣就自己去钻研一下SQL