|
# 是不是和 left join 一样了? >> direct join -------------- # 如果用right join 同不用 Join 直接挑资料是相同的,它等介於以下的指令 select a.id,a.name,b.dept_id from emp a ,emp_dept b where a.id=b.emp_id; mysql> select a.id,a.name,b.dept_id -> from emp a ,emp_dept b -> where a.id=b.emp_id; +----+----------+---------+ | id | name | dept_id | +----+----------+---------+ | 2 | Dennis-2 | DEv | | 1 | Dennis-1 | R&D | | 3 | Dennis-3 | R&D | | 4 | Dennis-4 | Test | | 5 | Dennis-5 | Test | +----+----------+---------+ 怎样,弄明白了吗? Enjoy it! |
正在阅读：数据库学习:MySQL Join详解数据库学习:MySQL Join详解
2004-04-01 13:26
出处：CSDN
责任编辑：linjixiong
键盘也能翻页，试试“← →”键
