Hello everybody, I'm working on some code that generated this query: select csGroups.ID as groupid,csUsers.UserName as username,csGroups_lang.Title as grouptitle,csUsers.ID as uid from csGroups_lang,csUsers,csGroups,csUsers_Groups where csGroups.ID = csGroups_lang.ID and csUsers.ID = csUsers_Groups.UserID and csGroups.ID = csUsers_Groups.GroupID and (csUsers.ID IN (1,2)) order by username asc limit 0,10 Through the DBI/DBD::Mysql interface I get this error: Unknown column 'csUsers_Groups.UserID' in 'where clause' But when I run it from the MySQL command prompt it runs cleanly. Does anyone have any insight into why this is acting this way? -Stephen
