CDbException:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.email_id' in 'field list'. The SQL statement executed was:
SELECT user.email_id
FROM `user` `t`
JOIN subscribe ON user.id = subscribe.user_id
WHERE subscribe.group IN (1,2,3)
GROUP BY user.id LIMIT 1
but my requirement is [sql]SELECT user.email_id
FROM user
JOIN subscribe ON user.id = subscribe.user_id
WHERE subscribe.group IN (1,2,3)
GROUP BY user.id;[/sql]
If [sql]SELECT user.email_id FROM usert[/sql], it gives the error, instant of the above i have write [sql]SELECT user.email_id FROM user[/sql] the output will come. why its not working with the (t). ?