thanks Joe, but I seem to still be getting a (missing operator) syntax error.
SELECT id, category_id, name
FROM auction_item_categories_sub5
INNER JOIN auction_item_categories_sub4 ON
auction_item_categories_sub5.category_id = auction_item_categories_sub4.id
INNER JOIN auction_item_categories_sub3 ON
auction_item_categories_sub4.categoryy_id = auction_item_categories_sub3.id
INNER JOIN auction_item_categories_sub2 ON
auction_item_categories_sub3.category_id = auction_item_categories_sub2.id
INNER JOIN auction_item_categories_sub ON
auction_item_categories_sub2.category_id = auction_item_categories_sub.id
INNER JOIN auction_item_categories ON
auction_item_categories_sub.category_id = auction_item_categories.id
where auction_item_categories.id = 1
>Joins are part of your "from" clause, not a seperate clause. This should help:
>
>
>SELECT id, category_id, name
>
>FROM auction_item_categories_sub5
> INNER JOIN auction_item_categories_sub4 ON
>auction_item_categories_sub5.category_id =
>auction_item_categories_sub4.id
> INNER JOIN auction_item_categories_sub3 ON
>auction_item_categories_sub4.categoryy_id =
>auction_item_categories_sub3.id
> INNER JOIN auction_item_categories_sub2 ON
>auction_item_categories_sub3.category_id =
>auction_item_categories_sub2.id
> INNER JOIN auction_item_categories_sub ON
>auction_item_categories_sub2.category_id =
>auction_item_categories_sub.id
> INNER JOIN auction_item_categories ON
>auction_item_categories_sub.category_id = auction_item_categories.id
>
> where auction_item_categories.id = 1
>
>-joe
>
>On Sat, 15 Jan 2005 17:31:21 -0400, Protoculture Breetai
><[EMAIL PROTECTED]> wrote:
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190600
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
