Need some help with a mysql error..haven't see this before.

[Ninjakreborn]

Any feedback on the following error I am facing.  Thanks.

 

SQL

select tf.Id,tf.Name,tf.LName,tf.Rank,tf.Category WHERE tf.Id not in (select fighter_id from tbl_player_fighter where league_id=91) AND  tf.Status ='1'

 

Error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE tf.Id not in (select fighter_id from tbl_player_fighter where league_id=91' at line 1

[PFMaBiSmAd]

Theres no FROM table_name term in that query.

[JonnoTheDev]

SELECT 
tf.Id,tf.Name,tf.LName,tf.Rank,tf.Category
FROM tablename

[Ninjakreborn]

Thanks I knew it had to be something simple, never used those before. Thanks again.