Hi! I have got two tables: 'item' and 'propertie'.
Table 'item' has index column named 'id_propertie' which refers to one row in table 'propertie'. Table 'propertie' has string column 'value'. I want to get the value of colun 'value' from table 'propertie' which index is same than in table 'item', BUT if the column 'id_propertie' in tabel 'item' is null the value for 'value' is 'empty'. Is it possible to make query like this? _______________________________________________________________________ Parhaat hakupalvelut yhdessä osoitteessa: http://www.eniro.fi/ Suomalaisten yritysten tuotteet ja palvelut: http://yritykset.eniro.fi/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]