mysql内查詢 外查詢_MYSQL基礎----連結查詢（内連接配接查詢，外連接配接查詢）

『1』内連接配接查詢

employee表

department表

select num,e.d_id,name,age,sex,homeaddr,d.d_name,d.function,d.address

from employee e,department d

where e.d_id=d.d_id;

『2』外連接配接查詢

@左連接配接(Left Join)查詢

資料表與上面同步

SELECT num,e.d_id,name,age,sex,homeaddr,d.d_name,d.function,d.address

FROM employee e left join department d

ON e.d_id=d.d_id;

@右連接配接(Right Join)查詢

資料表與上面同步

SELECT num,e.d_id,name,age,sex,homeaddr,d.d_name,d.function,d.address

FROM employee e right join department d

ON e.d_id=d.d_id;