[[u]b]join:[/b] [/u] return rows at least one match in tables
inner join is the most common join type used in applications ,and can be regarded
the default join type
[b]outer join[/b][u][/u]: outer join does not requires each record in the two records,outer join retains each record,
full join:return rows from the left join,even if there are no matches in right rows
left join: return rows from the right join, even if there are no matches in left rows
right join:return rows from all tables
inner join is the most common join type used in applications ,and can be regarded
the default join type
[b]outer join[/b][u][/u]: outer join does not requires each record in the two records,outer join retains each record,
full join:return rows from the left join,even if there are no matches in right rows
left join: return rows from the right join, even if there are no matches in left rows
right join:return rows from all tables
扫一扫
995
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
