Re: Very Odd Query problem

2012-12-25 Thread Sergiy Khohlov
please provide next output from mysql select * from view_usercontactemail where id in (2,3) Many thanks, Serge +380 636150445 skype: skhohlov 2012/12/23 Gerald Klein : > Hi all, I have a custom model mapped to a view, a join between a UserContact > model which carries

Very Odd Query problem

2012-12-23 Thread Gerald Klein
Hi all, I have a custom model mapped to a view, a join between a UserContact model which carries contacts for users and UserContactEmail which is the emails for the contacts. Very simple join. select concat(`t1`.`id`,'-',`t2`.`id`) AS `id`, `t2`.`usercontact_id` AS `usercontact_id`,