subject:"Multiple Self Joins and Left Joins \?"

Multiple Self Joins and Left Joins ?

2003-09-17 Thread Gary Huntress

I'm stumped by this query that I think will involve multiple self joins and left joins. My data looks like: +--+--++ | id | Category | description | +--+--++ |1 | color| red| |2 | color| blue | |3 | color

Re: Multiple Self Joins and Left Joins ?

2003-09-17 Thread Stephen Fromm

- Original Message - From: Gary Huntress [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM Subject: Multiple Self Joins and Left Joins ? I'm stumped by this query that I think will involve multiple self joins and left joins. My data looks like