i'm trying to relate(join or whatever) all tables in my database like this:
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 != ' '
but when i execute it i got this error:
"Error Code: 1054. Unknown column 'stokguncelleme.adeti' in 'field
list'"
Can anybody help me?
No comments:
Post a Comment