Error! Couldn't execute SQL.
select distinct tWine.wineid,imagefile,title,year,vineyard,description,price,numvotes,averagevote,colorname,regionname
from tWine,tRegion,tColor
left outer join tWineIngredient on (tWine.wineid = tWineIngredient.wineid)
where tWine.regionid = tRegion.regionid
and tWine.colorid = tColor.colorid and tWine.wineid = 196
1054 Unknown column 'tWine.wineid' in 'on clause' | |
