Well, I'll be ... I got it...!!! Here is my result query
select g.group_name, i.itemid, p.sku, p.title
from
sd_kit_groups g
INNER JOIN sd_kit_items i
ON g.id = i.groupid
INNER JOIN sd_products p
ON i.itemid = p.id
WHERE g.productid = '#url.id#'
group by g.group_name, i.itemid, p.sku, p.title
Thank you if you were looking at it .. !!
Paul Giesenhagen
QuillDesign
----- Original Message -----
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 10:30 PM
Subject: Big Join -- OOPs
> (Sorry didn't change subject on first message)
>
> I have another join question ... I am trying to get the following data:
>
> 1 PRODUCT is a KIT, the KIT consists of multiple GROUPS of PRODUCTS
>
> So, a Fishing Rod, Reel and Line combo would look like this:
>
> Fishing Rod Reel and Line Combo (main product)
>
> Choose a rod (group_name)
> Rod A (itemid - product)
> Rod B (itemid - product)
>
> Choose A Reel (group_name)
> Reel A (itemid - product)
> Reel B (itemid - product)
> Reel C (itemid - product)
>
> Choose Fishing Line (group_name)
> Line A (itemid - product)
> Line B (itemid - product)
>
> My tables are such:
>
> PRODUCT Table (which holds the main product (the combo) and the kit
products
> as well
> id, title, sku ...
>
> KIT GROUP Table (which holds the Choose a Rod, Choose a Reel ... groups)
> id, group_name, productid (Main product)
>
> KIT GROUP ITEMS table (which is all the items for each group)
> id, groupid, itemid (which is a product id)
>
> Whew ... any of you joiners out there?
>
> Thanks
>
> Paul Giesenhagen
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
