SQL-SERVER
-
编辑 删除
SQL内联接和外联接
SQL内联接和外联接--inner joinselect * from tableA a join tableB b on a.id=b.id--left outer joinselect * from tableA a left join tableB b on a.id=b.id--rigth outer joinselect * from tableA a right join tableB b on a.id=b.id-- full outer joinselect * from tableA a full join tableB b on a.id=b.id--cross join,返回笛卡尔乘积select * from tableA a
