Re: RES: Aggregate + left outer join (Solution)

2002-08-15 Thread mmanickalal
PM| ||| |+> >---| | | | To: [EMAIL PROTECTED] | | cc: (bcc: manu manickalal/PRTGROUP) | | Subject: Re: RES: Aggregate + left o

Re: RES: Aggregate + left outer join

2002-08-09 Thread mmanickalal
| | To: manu manickalal/PRTGROUP| | cc: | | Subject: RES: Aggregate + left outer join | >

Aggregate + left outer join

2002-08-09 Thread mmanickalal
Hi, I am relatively new to MySQL.. I am having trouble getting an aggregate function and an outer join to work together. I have two tables PROJECT (id_project, nm_project) 100, prj1 101, prj2 DAYLOG (id_project, date, hours) 100, 2002-08-17, 8 100, 2002-08-18, 8 DAYLOG table contains numbe