yedefaxing2010
yedefaxing2010
2011-06-27 16:47

sql语句

  • oracle
  • 数据库

小弟现在遇到一个sql问题。请各位路过高手援手
数据库:Oracle
表1(d_client_info):
ID,NAME,ENTITY,VERSION,DESCRIBE,ENTITYSIZE,STATE,UPDATEFLAG,CRTDATE,SUPPVERSION,HASHCODE,VERSIONCODE,PUBLISHDATE,STATUS,VERSIONFLAG,PACKNAME
表2(d_client_zip_info):ID,NAME,ENTITY,VERSION,ENTITYSIZE,SUPPVERSION,FLAG,CRTDATE
表3(m_client_zip_ref ):ID,,ZIPID,CLIENTID
SQL: select a2.id zipId ,a1.id resourceId, a1.name, a1.entitysize apksize, a2.entitysize zipsize,
a1.hashcode, a1.versioncode packagecode, a1.packname packagename, a1.version

from d_client_info a1, d_client_zip_info a2, m_client_zip_ref a3

where a3.zipid=a2.id and a3.clientid=a1.id and a2.flag=1 and a1.suppversion=#SUPPVERSION#

问题:能不能将这条sql中查询的字段都从表1中读取出来。不从表2和表3中拿数据。

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

5条回答