草根官道精校版:sql查询语句
来源:百度文库 编辑:中科新闻网 时间:2024/10/02 08:45:55
第一句是:这一句返回唯一的JIJINGLGSJGDM
select JIJINGLGSJGDM from fund_base_info where zhengquandm='377010';
然后第二句是
select JIJINJC from fund_base_info where JIJINGLGSJGDM='第一句的结果'
怎么把他们合并为一句啊,数据库是ORACLE
select JIJINGLGSJGDM from fund_base_info where zhengquandm='377010';
然后第二句是
select JIJINJC from fund_base_info where JIJINGLGSJGDM='第一句的结果'
怎么把他们合并为一句啊,数据库是ORACLE
select JIJINJC from fund_base_info where JIJINGLGSJGDM=(select JIJINGLGSJGDM from fund_base_info where zhengquandm='377010')
顺便说一下,楼主,这叫子查询
select JIJINJC from fund_base_info
where zhengquandm='377010';