Doing full joins and gettting problems

[bbram]

Hello I am prewriting my sql statements in the php myadmin that I currently have.  I will then be inserting them into php after I get them all written.  But I am getting a an error...Unknown column 'player_number.doubles_ladder' in 'field list'

 

 

The sql statement that I have is as follows:

 

SELECT rungs.rung_number, player_number.doubles_ladder, player_number2.doubles_ladder
FROM rungs
FULL JOIN rungs
ON doubles_ladder.rung_number=rungs.rung_number ORDER BY rungs.rung_name

 

Although I know I have player_number inside my doubles_ladder table.

 

[/code]