c/c++ Mysql query

[Devlinn]

query << "SELECT `name` FROM `players` WHERE `name` FROM `accounts` = " << accno << " AND `deleted` = 0 FROM `players` ";

error
mysql_real_query<>: SELECT `name` FROM `players` WHERE `name` FROM `accounts` = 123 AND `deleted` = 0 FROM `players` - MYSQL ERROR: you have an error in your SQL syntax: check the manual that corresponds to your MySQL serwer version for the right syntax to use near FROM `accounts` = 123 AND `deleted` = 0 FROM `players` at line 1 <1064>

 

[HalfAway]

You can't select FROM twice in a statment like this with two diffrent tables, you can try to achieve this with INNER JOIN instead.
http://www.w3schools.com/sql/sql_join_inner.asp