Re: DB Table Join problem

2006-09-23 Thread Malcolm Tredinnick
On Sat, 2006-09-23 at 18:35 +0100, Tom Smith wrote: > I have a model that is trying to join (sloppily) across 3 tables. > KnownCategories are a "group by catalog" reduction of Product.catalog > (because I thought it would be quicker but I don't know if I'm > right)...they should join like th

DB Table Join problem

2006-09-23 Thread Tom Smith
I have a model that is trying to join (sloppily) across 3 tables. KnownCategories are a "group by catalog" reduction of Product.catalog (because I thought it would be quicker but I don't know if I'm right)...they should join like this... Product.catalog <--> KnownCategory.fk_name <-