On Thu, 08 May 2008 15:08:31 -0700, cmgmyr wrote:

> On May 8, 4:39Â*pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> SELECT p.id, p.styleno, t1.name AS category1, t2.name as category2,
>> t3.name as category3, p.description, p.price, p.sort
>> Â*FROM categories AS t1
>> LEFT JOIN categories AS t2 ON t2.parentid = t1.id LEFT JOIN categories
>> AS t3 ON t3.parentid = t2.id INNER JOIN products AS p ON p.category =
>> COALESCE(t3.id,t2.id,t1.id);
>
> Thank you very much for that. It's very close. The only problem is, is
> that if an item has 2 categories it shows as 2 rows, if it has 3
> categories, it shows 3 times. Any ideas?

Use SELECT DISTINCT rather than SELECT

--
Remove caps to reply