HERE's my SQL dump...
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 ;
--
-- Dumping data for table `jobType`
--
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);
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
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=14 ;
--
-- Dumping data for table `jobs`
--
INSERT INTO `jobs` VALUES (4, 4, '2007-02-19', 1, 1, 1, 1);
INSERT INTO `jobs` VALUES (5, 4, '2007-02-19', 2, 2, 2, 2);
INSERT INTO `jobs` VALUES (6, 4, '2007-02-19', 3, 3, 3, 3);
INSERT INTO `jobs` VALUES (7, 4, '2007-02-19', 4, 4, 4, 4);
INSERT INTO `jobs` VALUES (8, 4, '2007-02-19', 5, 5, 5, 5);
INSERT INTO `jobs` VALUES (13, 0, '2007-02-19', 0, 0, 0, 0);
INSERT INTO `jobs` VALUES (12, 0, '2007-02-19', 0, 0, 0, 0);
On 04/04/07, Tris <[EMAIL PROTECTED]> wrote:
Hi Rudy.. I mean everyone ;-p
i've two tables:
JobType
id (int)
name (varChar)
Jobs
id (int)
user (int)
week (date)
day (int)
jobNo (int)
jobType (int)
hours (int)
I want to list all job types, and IF there's any corresponding with
the jobs table, I want to marry them up.
I've used this:
SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day
FROM jobType
RIGHT JOIN jobs on
jobs.jobType = jobType.id
But I'm only getting results if there's the Jobtype id in the jobs table..
Anyhoo... how can I list all jobTypes, and 'fill in the gaps'?
I've googled OUTER joins, but Im getting errors...?? Hmmmmm
--
When a person can no longer laugh at himself, it is time for others to
laugh at him.
Thomas Szasz
--
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: [email protected]
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.
