17,086
社区成员
发帖
与我相关
我的任务
分享连接查询为什么出错呢？
我在Pldeveloper和SQL*PLUS里面只要用join关键字作连接查询查询就出错，为什么啊？
select s.student_id,d.department_id from tbl_student s cross join tbl_department d
select s.student_name,d.depaetment_name from tbl_student s join tbl_department d on (d.department_id = s.department_id)
select s.student_name,d.depaetment_name from tbl_student s left outer join tbl_department d on (d.department_id = s.department_id)
哪位大侠知道这是为什么啊？
select s.student_id,d.department_id from tbl_student s cross join tbl_department d
select s.student_name,d.depaetment_name from tbl_student s join tbl_department d on (d.department_id = s.department_id)
select s.student_name,d.depaetment_name from tbl_student s left outer join tbl_department d on (d.department_id = s.department_id)
哪位大侠知道这是为什么啊？
...全文
请发表友善的回复…
发表回复
