成都seven eleven:请教sql连接的语法

被各式各样的连接搞糊涂了

内连接,外连接.左连接.右连接.左外连接.右外连接

稍微指点一下就可以了
tb1 id name ib2 id score

select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id=tb2.id

select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id=tb2.id(+)

select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id(+)=tb2.id

select tb1.id,tb1.name,tb2.scroe
from tb1
left join tb2 where tb1.id=tb2.id

select tb1.id,tb1.name,tb2.scroe
from tb1
left out join tb2 where tb1.id=tb2.id

select tb1.id,tb1.name,tb2.scroe
from tb1
INNER JOIN join tb2 where tb1.id=tb2.id

select tb1.id,tb1.name,tb2.scroe
from tb1
right out join tb2 where tb1.id=tb2.id

select tb1.id,tb1.name,tb2.scroe
from tb1
right join tb2 where tb1.id=tb2.id
(1)select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id=tb2.id

(2)select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id=tb2.id(+)

(3)select tb1.id,tb1.name,tb2.score
from tb1,tb2
where tb1.id(+)=tb2.id

(4)select tb1.id,tb1.name,tb2.scroe
from tb1
left join tb2 where tb1.id=tb2.id

(5)select tb1.id,tb1.name,tb2.scroe
from tb1
left out join tb2 where tb1.id=tb2.id

(6)select tb1.id,tb1.name,tb2.scroe
from tb1
INNER JOIN join tb2 where tb1.id=tb2.id

(7)select tb1.id,tb1.name,tb2.scroe
from tb1
right out join tb2 where tb1.id=tb2.id

(8)select tb1.id,tb1.name,tb2.scroe
from tb1
right join tb2 where tb1.id=tb2.id

1.第1个和第6个区别
2.(2),(3)的+是不是就是左连接和右连接
3.(4)(5)和(7)(8) 区别就一个out,有什么区别
谢谢大家了