MySQL Error: Column 'platform' in where clause is ambiguous
Attempted query:
SELECT DISTINCT
gamename,
gameid,
p.platform
FROM
cheats c,
platforms p
WHERE
p.platformNF = c.platform
AND
LEFT(gamename,1) = 'D' AND platform = 'playstation'
ORDER BY
gamename