有不同的。
create table ta(
kno int primary key,
c1 int)
create table tb(
kno int primary key,
c2 int)
insert into ta(kno,c1) select 1,100 union select 2,90
insert into tb(kno,c2) select 1,70 union select 3,null
用select ta.kno,ta.c1,tb.c2
from ta left join tb
on ta.kno=tb.kno會得到兩條記錄
用select ta.kno,ta.c1,tb.c2 from ta,tb
where ta.kno=tb.kno只有一條記錄