ORA9I学习笔记_0614_外联结查询

ORA9I学习笔记_0614_外联结查询

1.MSSQL 标准格式:

  SELECT ... FROM table_a LEFT/RIGHT OUTER JOIN table_b ON table_a.XX=table_b.XX

 

SELECT a.sname,t.* FROM commxyw t LEFT OUTER JOIN axy a ON t.scode=a.scode WHERE t.dm=1 ORDER BY t.jhjdmlist,t.yhlblist,t.scode,t.mark,t.step_no

 

 

2.ORA9i 简写格式:

  SELECT ... FROM table_c,table_d WHERE table_c.xx=table_d.xx(+)

 

SELECT a.sname,t.* FROM commxyw t ,axy a WHERE t.scode=a.scode(+) AND t.dm=1 ORDER BY t.scode,t.mark,t.jhjdmlist,t.yhlblist,t.step_no