我希望的结果是:
NUM NAME JOB SAL
---- ------------ ------------ ----------
7499 ALLEN SALESMAN 1600
7566 JONES MANAGER 2975
7698 BLAKE MANAGER 2850
7782 CLARK MANAGER 2450
7788 SCOTT ANALYST 3000
7839 KING PRESIDENT 5000
7902 FORD ANALYST 3000
NUM NAME JOB SAL
---- ------------ ------------ ----------
7499 ALLEN SALESMAN 1600
7566 JONES MANAGER 2975
7698 BLAKE MANAGER 2850
7782 CLARK MANAGER 2450
7788 SCOTT ANALYST 3000
7839 KING PRESIDENT 5000
7902 FORD ANALYST 3000
---- ------------ ------------ ----------
7499 ALLEN SALESMAN 1600
7566 JONE SMANAGER 2975
7698 BLAKE MANAGER 2850
7782 CLARK MANAGER 2450
7788 SCOTT ANALYST 3000
7839 KING PRESIDENT 5000
7902 FORD ANALYST 3000
谢谢各位了~!!!!
看上去好像是查询结果诶。
而查询结果显示:你好像没有用外关联诶。
把你的SQL语句贴出来看看。