>>>> 2011/04/25 18:45 +0000, Larry McGhaw >>>> CREATE VIEW `myview2` AS SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName` FROM `mytable` a LEFT JOIN `types` b ON a.`Type` = b.`ID`; <<<<<<<< Well, for this construct IF(b.`Name` IS NULL, '', b.`Name`) there is a special function IFNULL: IFNULL(b.`Name`, '') It has the same special type-treatment that IF has.
I quite often use it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org