我在Pldeveloper和SQL*PLUS里面只要用join关键字作连接查询查询就出错,为什么啊?
select s.student_id,d.department_id from tbl_student s cross join tbl_department dselect 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 dselect 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)
哪位大侠知道这是为什么啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货