交叉连接:将两个表粗暴的连接起来显示
格式:select * from [表1] cross join [表2]
相等连接:通过外键匹配显示表
格式:select * from [表1] join [表2] on [表1.字段名]=[表2.字段名]
自然连接:去掉同名列显示
格式:select * from [表1] natural join [表2]
交叉连接:将两个表粗暴的连接起来显示
格式:select * from [表1] cross join [表2]
相等连接:通过外键匹配显示表
格式:select * from [表1] join [表2] on [表1.字段名]=[表2.字段名]
自然连接:去掉同名列显示
格式:select * from [表1] natural join [表2]