[thelist] MySQL Table fields
rudy
r937 at interlog.com
Thu Jan 23 15:22:01 CST 2003
you had
FROM Items, Category
INNER JOIN category, items
ON Items.Category = Category.Category
which is an invalid construction (you're retrieving four tables)
what you want is
FROM Items
INNER JOIN Category
ON Items.Category = Category.Category
but you will still have a problem because in your SELECT list, you have two
columns called Category -- Items.Category and Category.Category
since you are making these equal anyway, you should omit one of them
rudy
More information about the thelist
mailing list