MySQL Joins no permission

[calimero1505]

Hi,

One of our customers complains about not having access to the LEFT JOIN command in MySQL. He has no permissions.

I have not an complete error, but does anyone knows something about this and how to correct it?

[calimero1505]

No one who knows? :(

[jaapvstr]

I'm not sure what it might be, but on google i found that it might have something to do with show_view privileges on tables.

On the mysql.db table, does the user has Show_view_priv set to Y for both the tables?

If not, try to set those to Y and see if that solves it. It normally is be set to Y there by directadmin.