Answer the question
In order to leave comments, you need to log in
The request is not working correctly, what's the problem?
SELECT *
FROM `t1`
JOIN `t2`
ON `t1`.`pav` = `t2`.`pac`
RIGHT JOIN `t3`
ON `t3`.`objid` = `t2`.`objid`
WHERE
`t2`.`objid` IS NULL
OR `t2`.`date` > '.....'
Answer the question
In order to leave comments, you need to log in
where t2.objid is null or (t2.date > '.....')
That's why. It's the same condition.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question