Search code examples
mysqlsqlsqlyog

Unknown column "..." in "where clause"

I'm having this problem with a specific task:

SELECT radnik.*, nalog.prioritetNalog FROM radnik
INNER JOIN nalog ON radnik.sifRadnik=nalog.sifRadnik
WHERE kvar.nazivKvar ="Zamjena klipa";

Results in:

Error Code: 1054
Unknown column 'kvar.nazivKvar' in 'where clause'

It says this, but the column and datatable exist

https://i.sstatic.net/mQZt4.jpg

Solution

  • I was missing one more join, thanks for the help

    SELECT radnik.*, nalog.prioritetNalog FROM radnik
inner JOIN nalog ON radnik.sifRadnik=nalog.sifRadnik
inner join kvar on nalog.sifKvar=kvar.sifKvar 
WHERE kvar.nazivKvar ="Zamjena klipa";