[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