title: mysql unknown column in field list
body: <p>i'm trying to relate(join or whatever) all tables in my database like this:</p>
  
  <pre><code>Select stoktablosu.BarkodNo, marka.markaAd, model.Modelkod, urun.UrunGrubu, renkkod.RenkAdi, stoktablosu.beden, model.sezon,stokguncelleme.adeti ,stoktablosu.StokYeri, toptanfiyat.Tarih, toptanfiyat.AlisFiyati, toptanfiyat.GuncelSatisFiyati, stokguncelleme.eklenencikarilan  
  from magazayonetim.marka 
  inner join stoktablosu_has_marka on stoktablosu_has_marka.marka_MarkaKod =  marka.MarkaKod  
  inner join model on model.marka_MarkaKod = marka.MarkaKod  
  inner join renkkod_has_marka on renkkod_has_marka.marka_MarkaKodu = marka.MarkaKod  
  inner join renkkod on renkkod.renkkodu = renkkod_has_marka.renkkod_RenkKodu  
  inner join marka_has_urun on marka_has_urun.marka_MarkaKod = marka.MarkaKod 
  inner join urun on urun.urunKodu = marka_has_urun.urun_UrunKodu   
  inner join toptanfiyat on toptanfiyat.BarkodNo = stoktablosu.BarkodNo 
  inner join stoktablosu on stoktablosu.BarkodNo = stoktablosu_has_marka.stoktablosu_BarkodNo  
  and stoktablosu.BarkodNo = stokguncelleme.BarkodNo
  and stoktablosu.renk_renkkodu = renkkod.renkkodu 
  and stoktablosu.model_modelkod = model.modelkod
  and stoktablosu.urun_urunkodu = urun.urunKodu  
  where stokguncelleme.adeti != '0' 
  and stoktablosu.BarkodNo  = '01012340138483814İY'  
  and marka.markaAd != ' ' and urun.UrunGrubu != ' ' and model.Modelkod != ' ' and stoktablosu.Beden != ' ' and renkkod.RenkAdi != ' ' and stoktablosu.StokYeri != ' ' and model.sezon != ' '
  </code></pre>
  
  <p>but when i execute it i got this error: </p>
  
  <blockquote>
    <p>"Error Code: 1054. Unknown column 'stokguncelleme.adeti' in 'field
    list'"</p>
  </blockquote>
  
  <p>Can anybody help me?</p>