[SOLVED] What does this error mean?

[EchoFool]

 

Unknown column 'm_table.ID' in 'IN/ALL/ANY subquery'

 

For the record that field does exist in that table !

 

My query:

 

$Find = mysql_query("SELECT m_table.Name FROM m_table INNER JOIN m_story ON m_table.ID=m_story.ID
				WHERE m_story.Url='$Url' AND m_story.CityID='$CityID' AND m_story.Stage='0' AND m_table.Live=1 AND m_table.ID NOT IN 
				( SELECT ID FROM m_users WHERE UserID='{$_SESSION['Current_User']}')")
			Or die(mysql_error());	

 

I've used the NOT IN  before many times, don't get why it crashed this time though this is first time i used one with a inner join.. is that a link ?

[EchoFool]

Argh dw some one helped me out on msn never mind