PM|
|||
|+>
>---|
| |
| To: [EMAIL PROTECTED] |
| cc: (bcc: manu manickalal/PRTGROUP) |
| Subject: Re: RES: Aggregate + left o
|
| To: manu manickalal/PRTGROUP|
| cc: |
| Subject: RES: Aggregate + left outer join |
>
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