tags:

views:

34

answers:

1
Q: 

Merging multiple tables into one result

Hi,

I have two tables for a facebook and twitter stream. Those tables have to be separated, so there's no point merging them into one table. But here's the thing. I want to have all the results from those two tables merged into one result and I cant seem to figure out how to get that working.

Oh, and it has to be fast. I read something about merging multiple tables into one table and then getting the results from that but that doesn't seem fast enough for me.

Should I do it in PHP and MySql or can it be done just in native MySql (preferred).

The results will be ordered by date which is saved in both tables.

Can anyone help me, or point me in the right direction?

Thanks!

A: 

Have you had a look at

UNION ALL

astander  2010-10-12 09:06:00
Thanks for the fast response. That's what I was looking for. But it's not possible to use the primary key of each table. Only the first tables primary key is shown. Any ideas? PS: They both have a different name e.g. facebook_id and twitter_id.
frietkot  2010-10-12 09:26:30

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL