mysql的联合查询

上一篇 / 下一篇  2018-07-13 14:07:27 / 个人分类：其他

查看( 1084 ) / 评论( 1 ) / 评分( 0 / 0 )
mysql不支持full join的语法，可以支持下面的查询。
SELECT aws.*,cases.* from aws LEFT JOIN cases on aws.id = cases.aw_id

SELECT aws.*,cases.* from aws RIGHT JOIN cases on aws.id = cases.aw_id

SELECT aws.*,cases.* from aws JOIN cases on aws.id = cases.aw_id

SELECT aws.*,cases.* from aws INNER JOIN cases on aws.id = cases.aw_id

SELECT aws.*,cases.* from aws LEFT JOIN cases on aws.id = cases.aw_id UNION SELECT aws.*,cases.* from aws RIGHT JOIN cases on aws.id = cases.aw_id

SELECT aws.*,cases.* from aws,cases WHERE aws.id = cases.aw_id

收藏 举报

TAG: SQL sql

引用 删除 2243148804   /   2018-08-23 16:49:28
没明白这些语句是什么意思
 

评分：0

我来说两句

Open Toolbar