My database tables (example):
table "houses":
+----------+------------+-------+
| house_id | house_name | price |
+----------+------------+-------+
| 1 | house1 | 22 |
+----------+------------+-------+
| 2 | house2 | 14 |
+----------+------------+-------+
table "flats":
+----------+---------------+--------+--------------+
| flat_id | flat_name | price | unique_flat_column |
+----------+---------------+--------+--------------+
| 1 | flat1 | 11 | NULL |
+----------+---------------+--------+--------------+
| 2 | flat2 | 18 | NULL |
+----------+---------------+--------+--------------+
I explain:
I can not have all objects (I mean houses, flats, ...) in one table, because they all have unique features.
My question:
I want to query, for example, three highest prices of all objects, it means I shoul get (in order): house1, flat2, house2.
I would be thankful for any help or web links.
Thanks
