Re: WHERE does not work on calculated view field

Hi Daniel, Could you check the 'myview' once again? I think you thought to create the view as follows: CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*; Now your select queries will give results as

Re: WHERE does not work on calculated view field

Hi, thanks for the answer! On 04/23/11 11:33, ars k wrote: Could you check the 'myview' once again? I think you thought to create the view as follows: CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*;