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.