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'
That is because child_id is not a valid column in that table. There is child_user_id and child_group_id.
It looks like you're new here. Sign in or register to get started.
