Untitled

SELECT Items.ItemID, Items.YR2, Items.Item_Name, Items.QCode, Condition.Condition, Items.Price, Items.Picture, Items.Dated, Items.Code, YTEMP.YR FROM Items,Condition,Year as YTEMP WHERE Items.YR2 = YTEMP.YR2 AND Items.MaterialID = Condition.Code AND Items.CatID = Category.CatID AND Items.CatID = '13' ORDER BY Item_Name