RE:[2] Complex Left Join

2001-12-20 Thread Brian E . Lozier
n > >-Original Message- >From: Brian E. Lozier [mailto:[EMAIL PROTECTED]] >Sent: 20 December 2001 10:14 >To: [EMAIL PROTECTED] >Subject: Complex Left Join > > >I'm trying to accomplish something a bit complex with a single query. >Basically, I'm doing a n

RE: Complex Left Join

2001-12-20 Thread Simon Green
Can OPTIMIZE help at all? Simon -Original Message- From: Brian E. Lozier [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 10:14 To: [EMAIL PROTECTED] Subject: Complex Left Join I'm trying to accomplish something a bit complex with a single query. Basically, I'm doin

Complex Left Join

2001-12-20 Thread Brian E . Lozier
I'm trying to accomplish something a bit complex with a single query. Basically, I'm doing a nested category/file listing, and I want to get the number of categories and the number of files under each category in the list. For example: http://www.massassi.org/saberworks/files.php user: kedri