RE: 1 to many query

2005-02-11 Thread livejavabean
ysql.com Subject: RE: 1 to many query > -Original Message- > From: Tom Crimmins > Sent: Thursday, February 10, 2005 17:08 > To: livejavabean > Cc: mysql@lists.mysql.com > Subject: RE: 1 to many query > > > > -Original Message- > > From: livejav

RE: 1 to many query

2005-02-10 Thread Tom Crimmins
> -Original Message- > From: Tom Crimmins > Sent: Thursday, February 10, 2005 17:08 > To: livejavabean > Cc: mysql@lists.mysql.com > Subject: RE: 1 to many query > > > > -Original Message- > > From: livejavabean > > Sent: Thurs

RE: 1 to many query

2005-02-10 Thread Tom Crimmins
> -Original Message- > From: livejavabean > Sent: Thursday, February 10, 2005 16:47 > To: mysql@lists.mysql.com > Subject: 1 to many query > > Hi there.. > > > > Hope you can give me some thoughts on this. let say we have 3 tables > > > > table 1 (pk=project_id) > === > - proj