How to write such query?

[Mike Mapsnac]

I want to get distinct title from  table titles. But there are two differnt 
titles (new and used).So I need somehow join all three tables where 
user_tiles
status='true' and titles are distinctive. Thanks



titles
+-------------------+-------------------------------+------+-----+---------+----------------+
| Field             | Type                          | Null | Key | Default | 
Extra          |
+-------------------+-------------------------------+------+-----+---------+----------------+
| title_id          | int(5)                        |      | PRI | NULL    | 
auto_increment |
| titles            | varchar(5)                    |      | MUL |         | 
               |
| quantity          | int(5)                        |      |     | 0       | 
		    |
| condition         | enum('new', 'used')           |      |     |         | 
               |
+-------------------+-------------------------------+------+-----+---------+----------------+

new_titles
+------------+----------------------+------+-----+---------+-------+
| Field      | Type                 | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+-------+
| title_id   | int(8)               |      | PRI | 0       |       |
| cost       | decimal(5,2)         |      |     | 0.00    |       |
used_titles
+--------------------+----------------------------------------------------------+------+-----+---------------------+-------+
| Field              | Type                                                  
   | Null | Key | Default             | Extra |
+--------------------+----------------------------------------------------------+------+-----+---------------------+-------+
| title_id           | int(8)                                                
   |      | PRI | 0                   |       |
| status             | enum('true','false')                                  
   |      |     | true                |       |

_________________________________________________________________
Learn how to choose, serve, and enjoy wine at Wine @ MSN. 
http://wine.msn.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]