Error when executing statement

[Thomas Daniels]

mysql> SELECT cu.lower_user_name, cg.lower_group_name
-> from cwd_user cu
-> join cwd_membership cm on cu.id=cm.child_id
-> join cwd_group cg on cm.parent_id=cg.id
-> WHERE cu.directory_id=163842 AND cg.directory_id=28868609
-> into outfile '/tmp/outfile.cvs' fields terminated by ',' enclosed by '' lines terminated by '\n';
ERROR 1054 (42S22): Unknown column 'cm.child_id' in 'on clause'

[Davin Studer]

That is because child_id is not a valid column in that table. There is child_user_id and child_group_id.