[stabker]

Quote:

Originally Posted by Stepashka Code: SELECT *, IFNULL((SELECT name FROM users WHERE biz.owner_id = users.id), '') AS owner_name FROM biz WHERE owned

Спасибо! Теперь буду знать. Только мне, скорее, нужно так:

Code:

SELECT
	*,
	IF(biz.owned, (SELECT name FROM users WHERE biz.owner_id = users.id), "") AS owner_name
FROM biz