日期:2014-05-16 浏览次数:20987 次
SQL> with TAB_A as ( 2 select '王辉' name, 100 id,90 score from dual), 3 TAB_B as ( 4 select '王辉' name, 100 id,'山东' addr from dual) 5 select TAB_A.NAME,TAB_A.ID,TAB_A.SCORE,TAB_B.ADDR FROM TAB_A,TAB_B WHERE TAB_A.ID=TAB_B.ID; NAME ID SCORE ADDR ---- ---------- ---------- ---- 王辉 100 90 山东 SQL>