Code: Select all
SELECT * FROM `vacancies` as `v`
INNER JOIN `options` as `o1` ON `o1`.`optionID` = `v`.`jobTitle`
INNER JOIN `options` as `o2` ON `o2`.`optionID` = `v`.`jobLocation`
INNER JOIN `options` as `o3` ON `o3`.`optionID` = `v`.`jobBusiness`
GROUP BY `v`.`jobID`
Code: Select all
SELECT * FROM `vacancies` as `v`
INNER JOIN `options` as `o` ON `o`.`optionID` = `v`.`jobTitle`, `o`.`optionID` = `v`.`jobLocation`, `o`.`optionID` = `v`.`jobBusiness`
GROUP BY `v`.`jobID`Code: Select all
vacancies CREATE TABLE `vacancies` (
`jobID` int(10) NOT NULL auto_increment,
`jobTitle` varchar(255) default NULL,
`closingDate` int(11) default NULL,
`adText` text,
`refNo` varchar(255) default NULL,
`jobLocation` int(3) default NULL,
`datePosted` int(11) default NULL,
`jobBusiness` int(3) default NULL,
PRIMARY KEY (`jobID`)
) TYPE=MyISAMCode: Select all
options CREATE TABLE `options` (
`optionID` int(10) NOT NULL auto_increment,
`optionCat` varchar(255) default NULL,
`optionName` varchar(255) default NULL,
PRIMARY KEY (`optionID`)
) TYPE=MyISAM