Combining unrelated tables

Databases
1

Hi,

I currently have an existing property database and I have started importing property data from another website. Their information is in a totally different format (fields, comma delimited) than mine, so I have created separate tables for their data.

I now have unrelated tables for each set of properties.

The issue I came across was displaying a list of combined properties on a property search, both theirs and mine, so having looked around on google decided to carry out a select on each set of tables and then insert the results into a temporary table which I use to show the combined results. This works, but I’m wondering if there is a better way or what drawbacks this method has?

Thanks for any advice.

2

if you can insert the results of different SELECTs into the same temporary table, then you can use those same SELECTs in a UNION query to avoid the temp table altogether

3

Thanks Rudy, I’ll do that.