关于sql语句的问题 where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句select a.line_code,b.line_code,b.line_name,a.measure_id,a.measure_name,a.measure_type from measure_cell a,line_base b where a.line_code=b.lin
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/31 05:07:24
![关于sql语句的问题 where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句select a.line_code,b.line_code,b.line_name,a.measure_id,a.measure_name,a.measure_type from measure_cell a,line_base b where a.line_code=b.lin](/uploads/image/z/14947359-15-9.jpg?t=%E5%85%B3%E4%BA%8Esql%E8%AF%AD%E5%8F%A5%E7%9A%84%E9%97%AE%E9%A2%98+where+a.line_code%3Db.line_code%28%2B%29+%2C%EF%BC%88%2B%EF%BC%89%E6%98%AF%E6%80%8E%E4%B9%88%E5%9B%9E%E4%BA%8B+%2C%E5%85%B7%E4%BD%93%E7%82%B9+%2C%E6%9C%80%E5%A5%BD%E6%9C%89%E4%BE%8B%E5%8F%A5select+a.line_code%2Cb.line_code%2Cb.line_name%2Ca.measure_id%2Ca.measure_name%2Ca.measure_type+from+measure_cell+a%2Cline_base+b+where+a.line_code%3Db.lin)
x){ںɮ>_|V^.PZj`khk*ӡ~O5=t'tnw
:4<]ٜ'& KMIMM,.-JLAɕT**DSsru%%*$MR>}qPe/)@%&ge2S
3S~}p(䤦(dgMS +U /.H̳-
关于sql语句的问题 where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句select a.line_code,b.line_code,b.line_name,a.measure_id,a.measure_name,a.measure_type from measure_cell a,line_base b where a.line_code=b.lin
关于sql语句的问题 where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句
select a.line_code,b.line_code,b.line_name,a.measure_id,a.measure_name,a.measure_type from measure_cell a,line_base b where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句
关于sql语句的问题 where a.line_code=b.line_code(+) ,(+)是怎么回事 ,具体点 ,最好有例句select a.line_code,b.line_code,b.line_name,a.measure_id,a.measure_name,a.measure_type from measure_cell a,line_base b where a.line_code=b.lin
这是oracle的语法
a.id=b.id(+)等价于
a left join b on a.id= b.id