Jump to content

[SOLVED] What does this error mean?


EchoFool

Recommended Posts

 

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 ?

Link to comment
https://forums.phpfreaks.com/topic/148689-solved-what-does-this-error-mean/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.