-
|+>
|| mmanickalal@en|
|| herent.com|
|||
|| 09-08-02 04:49|
||
Eduardo,
Thanks for the reply, but I still get only one record for prj1. While prj2
does not show up with 0 hours.
CREATE TABLE PROJECT (
ID_PROJECT int(11) NOT NULL auto_increment,
NM_PROJECT varchar(255) NOT NULL default ''
PRIMARY KEY (ID_PROJECT)
) TYPE=MyISAM;
INSERT INTO PROJECT
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
