SELECT
t1.idOpportunities, t2.idEmploymentType, t2.Description
FROM
    cnt4704p2.opportunities t1
        INNER JOIN
    cnt4704p2.employmenttype t2 ON t1.EmploymentTypeId = t2.idEmploymentType;

CREATE TABLE `opportunities` (
  `idOpportunities` int(11) NOT NULL,
  `Postion` varchar(150) DEFAULT NULL,
  `EmploymentTypeId` int(11) DEFAULT NULL,
  `PayRate` decimal(10,2) DEFAULT NULL,
  `PayPeriodTypeId` int(11) DEFAULT NULL,
  `idEmployers` int(11) DEFAULT NULL,
  PRIMARY KEY (`idOpportunities`),
  KEY `idEmployers_idx` (`idEmployers`),
  KEY `idEmploymentTypeId_idx` (`EmploymentTypeId`),
  KEY `fk_idPeriodType_idx` (`PayPeriodTypeId`),
  CONSTRAINT `fk_idEmployers` FOREIGN KEY (`idEmployers`) REFERENCES `employers` (`idEmployers`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_idEmploymentTypeId` FOREIGN KEY (`EmploymentTypeId`) REFERENCES `employmenttype` (`idEmploymentType`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_idPeriodType` FOREIGN KEY (`PayPeriodTypeId`) REFERENCES `periodtypes` (`idPeriodTypes`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `employmenttype` (
  `idEmploymentType` int(11) NOT NULL AUTO_INCREMENT,
  `Description` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idEmploymentType`),
  KEY `idx_EmploymentTypeId` (`idEmploymentType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;