I have three tables:
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
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.
UNION can't be operated as selected columns are different in number and compatibility.