[SQL] I need help with SQL

[LucasFerraz]

HI,
I got this sql

INSERT INTO gamecodes (gamecode, accountname, points, alreadyused) VALUES ('RANDOMCODE','PLAYERNAME',30,'N')

I need a sql code that find account name in table ACCOUNTS using PLAYERNAME

 

[dchampag]

Visual seperation to help you better understand left join

SELECT
accounts.name
FROM
accounts
LEFT JOIN
players
ON
players.account_id
WHERE
players.account_id = accounts.id
AND
players.name = 'PUTPLAYERNAMEHERE'

Code for SQL

SELECT accounts.name FROM accounts LEFT JOIN players ON players.account_id WHERE players.account_id = accounts.id AND players.name = 'PUTPLAYERNAMEHERE'