database query combine possibility |
07-16-2017, 12:19 PM
(This post was last modified: 07-16-2017, 12:20 PM by eagle00789. Edit Reason: typo fix )
i currently have to following 2 query's:
Code: SELECT `PersonelID` FROM `vacations` WHERE ( `FromDate` <= '2017-07-10' OR ( `FromDate` BETWEEN '2017-07-10' AND '2017-07-16' ) ) AND ( `ToDate` >= '2017-07-16' OR ( `ToDate` BETWEEN '2017-07-10' AND '2017-07-16' ) ) Code: SELECT `PersonelID`, `FirstName`, `LastName` FROM `personel` WHERE `PersonelID` NOT IN('3') AND `Active` = 1 ORDER BY `FirstName` ASC Code: SELECT `PersonelID`, `FirstName`, `LastName` FROM `personel` WHERE `PersonelID` NOT IN(SELECT `PersonelID` FROM `vacations` WHERE ( `FromDate` <= '2017-07-01' OR ( `FromDate` BETWEEN '2017-07-01' AND '2017-07-02' ) ) AND ( `ToDate` >= '2017-07-02' OR ( `ToDate` BETWEEN '2017-07-01' AND '2017-07-02' ) )) AND `Active` = 1 ORDER BY `FirstName` ASC PHP Code: $this->db->select('PersonelID')->from('vacations'); |
Messages In This Thread |
database query combine possibility - by eagle00789 - 07-16-2017, 12:19 PM
RE: database query combine possibility - by PaulD - 07-16-2017, 03:20 PM
|