Inner JOIN指令

• 我們通常使用inner join，以下指令全等
• Select xx from tb1,tb2 where tb1.a=tb2.b
• select xx from tb1 inner join tb2 on tb1.a=tb2.b
• select xx from tb1 join tb2 on tb1.a=tb2.b
• 範例：用汽車資料庫
• select service.sid, service.name, sale.num from sale,service where sale.sid=service.sid;
• select service.sid, service.name, sale.num from sale inner join service on sale.sid=service.sid;