MySQL – How to Select All Results from Two Independent Tables

MySQLselect

I have two tables:

Comments
--------
id
comment_content
time_stamp

Activities
-----------
id
activity_content
time_stamp

And I would like to combine the results from both, ordered by their timestamp fields.

Best Answer

Combine the two tables with UNION and ORDER BY timestamp. You can also add an addition (type) column so the source of a row can be identified:

SELECT 
    'comment' AS type, id, comment_content AS content, time_stamp
FROM
    comments

UNION ALL

SELECT 
    'activity', id, activity_content, time_stamp
FROM
    activities

ORDER BY 
    timestamp ;

Related Solutions

Mysql – Combine results from two queries

I would consider taking the union queries and make a view using them. You can then treat the union as if it was a table.

Mysql – Aggregate data from two tables with different field names

SELECT year, month, sum(pledged) AS Pledged, sum(donated) AS DONATED FROM
(
SELECT year(pledge_date) as year, month(pledge_date) as month, amount_pledged  as pledged, 0 as donated FROM pledges
UNION
SELECT year(processed_date) as year, month(processed_date) as month, 0 as pledged, amount_donated as donated FROM **donations**
)x 
GROUP BY year, month 
ORDER BY year, month

Best Answer

Related Solutions

Mysql – Combine results from two queries

Mysql – Aggregate data from two tables with different field names

Related Question