MySQL select query on 2 tables

[safra]

Hi,

I have 2 tables: properties and developments. Apart from a few fields, these 2 tables are identical. At the moment I have a seperate search form for both tables but I would like to join them into one search form and show them in 1 search results list.

Is this possible in one mysql query and perhaps order on price?

Thanks,
Raoul

[TTT]

i'm now sure did you actually mean this... but....

SELECT DISTICT(t1.id)  AS tid  

FROM table1 t1 
LEFT OUTER JOIN table2 t2 ON t1.id = t2.id 
LEFT OUTER JOIN table1 tt1 ON t2.id = tt1.id
ORDER BY t1.id ASC

[safra]

Thanks TTT!

I am familiar with LEFT JOIN. Not sure what LEFT OUTER JOIN does. But looking at the code you are matching on the id of both tables. I do not think this works well in my case (or is this the trick with LEFT OUTER JOIN?).

The 2 tables operate independently from each other. What I actually need is a temporary 3rd table that has all the records of both table 1 and 2. Where table 2 has 2 price fields: PriceFrom and PriceTo. All other fields in table 2 that are not included in table 1 are not important as they do not visually show up in the results list. It should also be possible to see if a record comes from table 1 or 2 and, ideally, the ORDER should sort on both Price in table 1 and PriceFrom in table 2.

Is this possible?

What does DISTICT(t1.id) actually do?