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

2002-08-15 Thread mmanickalal
| ||| |+ ---| | | | To: [EMAIL PROTECTED] | | cc: (bcc: manu manickalal/PRTGROUP) | | Subject: Re: 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

Re: RES: Aggregate + left outer join

2002-08-09 Thread mmanickalal
/PRTGROUP| | cc: | | Subject: RES: Aggregate + left outer join | ---| Hi, Try