Re: error 1054: Unknown column

[Andrew Zabolotny]

I've found the answer to my problem here:

http://www.zen-cart.com/forum/archive/index.php/t-46483.html

In short: You must enclose multiple tables for 'FROM ...' in parentheses. In my case, the correct fix is:


SELECT m.*
FROM ( cslan_gamemaps as m, cslan_defs_maps as def )
LEFT JOIN cslan_gamemaps_cstrike as mm ON mm.gamemapid=m.gamemapid

This works as expected.