'where子句'中的未知列，而列存在MySQL

Question

I have a weird problem when trying to run an SQL query in phpmyadmin. my query:

SELECT * FROM Dozen 
WHERE Dozen.registered = '1' 
AND Dozen.DoosID = Klant_Doos.DoosID 
AND Klant_Doos.KlantID = '1'

When running it in phpmyadmin on the right database with column Klant_Doos existing it returns the following error.

1054 - Unknown column 'Klant_Doos.DoosID' in 'where clause'

I've been doing some testing and this problem only seems to appear when i use

Table.Column = OtherTable.OtherColumn

If I use

Table.Column = 'Value'

it return results just fine.

Is it my syntax or did I just discover a bug in phpmyadmin?

Thanks in advance.

Answer 1

You seem to be missing a table reference in your from clause. Is this what you are trying to do?

SELECT *
FROM Dozen JOIN
     Klant_Doos
     ON Dozen.DoosID = Klant_Doos.DoosID 
WHERE Dozen.registered = '1' AND
      Klant_Doos.KlantID = '1';