Posted by Ac1d^ on 04/10/06 10:31

Select
Category.CategoryID,
Category.Category,
Category.Sorting,
Count(Listings.CategoryID)
From
Category LEFT JOIN Listings on(Listings.CategoryID=category.CategoryID)

Order By
Category.Sorting Desc

• Next in forum: Re: Check Box name as a session variable
• Prev in forum: Re: Check Box name as a session variable
• Thread view: Re: Count Number of Items in each Category

[Reply to this message]