|
Maybe because your "AS genres" conflicts with the table name "genres"??
You could try putting back ticks around the AS name: AS `genres`
I actually tried that query in my copy of MySQL 5.5 and it worked fine.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
|