:-( Here I go again... it really doesn't work... ? :-(
SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day FROM jobType LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id WHERE jobs.id IS NULL OR ( jobs.user = '4' AND jobs.week = '2007-03-19' AND ( jobs.day = '3' OR jobs.day = '0' ) ) CREATE TABLE `jobType` ( `id` int(12) NOT NULL auto_increment, `name` varchar(100) collate utf8_bin NOT NULL default '', `type` tinyint(10) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ; INSERT INTO `jobType` VALUES (1, 'Design', 0); INSERT INTO `jobType` VALUES (2, 'Meeting', 0); INSERT INTO `jobType` VALUES (3, 'PHP', 0); INSERT INTO `jobType` VALUES (4, 'Downtime', 0); INSERT INTO `jobType` VALUES (5, 'Copy', 0); INSERT INTO `jobType` VALUES (6, 'Other', 0); CREATE TABLE `jobs` ( `id` int(12) NOT NULL auto_increment, `user` int(10) NOT NULL default '0', `week` date NOT NULL default '0000-00-00', `day` tinyint(3) NOT NULL default '0', `jobNo` int(10) NOT NULL default '0', `jobType` int(10) NOT NULL default '0', `hours` tinyint(5) NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=19 ; INSERT INTO `jobs` VALUES (18, 4, '2007-03-05', 0, 45645, 0, 0); INSERT INTO `jobs` VALUES (4, 4, '2007-03-19', 1, 1, 1, 1); INSERT INTO `jobs` VALUES (5, 4, '2007-03-19', 2, 2, 2, 2); INSERT INTO `jobs` VALUES (6, 4, '2007-03-19', 3, 3, 3, 3); INSERT INTO `jobs` VALUES (7, 4, '2007-03-19', 4, 4, 4, 4); INSERT INTO `jobs` VALUES (8, 4, '2007-03-19', 5, 5, 5, 5); INSERT INTO `jobs` VALUES (13, 1, '2007-03-19', 2, 12, 6, 2); INSERT INTO `jobs` VALUES (12, 2, '2007-03-19', 4, 21, 3, 1); On 04/04/07, r937 <[EMAIL PROTECTED]> wrote:
> Ah, i'm on 4.1.11.... > that make a difference? none whatsoever ;o) ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
-- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to $subst('List.Name') as: $subst('Recip.EmailAddr') To unsubscribe send a blank email to $subst('Email.UnSub') To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.