That can be done with a Union query. But the first question is why you have this data in 2 tables to begin with? Are these tables coming from different sources? If they are part of your database design, it's probably wrong to begin with.
I have two tables for my forums database structure. One is for threads and the other is for replies. I have separated these because the thread needs to hold lots of data which the reply doesn't. For example: the reply doesn't require a 'views' column whereas a thread does.
lenton wrote:I have two tables for my forums database structure. One is for threads and the other is for replies. I have separated these because the thread needs to hold lots of data which the reply doesn't. For example: the reply doesn't require a 'views' column whereas a thread does.
I would guess that that's a poor database design, although without knowing the entire structure, I can't really tell. With a properly designed schema, Union queries are seldom needed.