Sql Jions 的简易理解

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A  left jion TableB  B on  A.key = B.key

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A  right jion TableB  B on  A.key = B.key

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A inner jion TableB  B on  A.key = B.key

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A left jion TableB  B on  A.key = B.key where B.key is NULL

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A right jion TableB  B on  A.key = B.key where A.key is NULL

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A full outer jion TableB  B on  A.key = B.key

Sql Jions 的简易理解-LMLPHP

Select  * from TableA A full outer jion TableB  B on  A.key = B.key  where A.key is NULL or B.key is NULL

05-22 15:29
查看更多