Question

Help with mySQL
Give the item number, description, and on-hand value(OnHand * Price) for each item in category GME

why is MySQL giving me an error?

Select ItemNum, Description, (OnHand * Price) AS On-Hand-Value
From item
Where Category = "GME";

Answer 1

Little tricky without item's schema.

Answer 2

I got it. It was because '-' is not an MySQL valid syntax