合并从两个单独的联接获得的结果

I have three tables:
users:

users table
blog

blog table

instagram

instagram table

我想从(用户和博客)和(用户和instagram)的内部联接获得结果,目前我正在为其执行这些查询 1.)

SELECT instagram.post_author,instagram.post_link,instagram.post_image,instagram.ts,users.username 
from instagram 
INNER JOIN users ON instagram.access_key=users.access_key ORDER BY instagram.ts DESC

2.)

SELECT blog.content,users.username,blog.ts 
from blog 
INNER JOIN users ON blog.access_key=users.access_key ORDER BY blog.ts DESC

I want to combine results from both of these queries but I can't figure out how to.
p.s: UNION can't be operated as selected columns are different in number and compatibility.

评论