K
K
Korifa2020-03-24 11:34:18
SQL
Korifa, 2020-03-24 11:34:18

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` > '.....'

All rows from table t3 are not displayed. 3 lines are displayed, although there are 95 of them in table t3

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Stanislav Valsinats, 2020-03-24
@Korifa

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 question

Ask a Question

731 491 924 answers to any question