If id is null after left join in mysql, the join condition disappears.

We have tables A, B, and C, and we would like to find A related to a particular C.

SELECT* 
FROM A A
  INNER JOIN B
    ON b.id = a.b_id
  LEFT JOIN CC
    ON c.b_id=b.id AND c.type='hogehoge'
WHERE c.id IS NULL

At this time, other types other than c.type='hogehoge' are also extracted.

mysql

2022-09-30 20:10

1 Answers

If you only want to extract records with type='hogehoge', use c.type='hogehoge' as an extraction condition, not a merge condition.

SELECT* 
FROM A A
  INNER JOIN B
    ON b.id = a.b_id
  LEFT JOIN CC
    ON c.b_id=b.id
WHERE c.type = 'hogehoge'

2022-09-30 20:10

Popular Tags

python x 4647

android x 1593

java x 1494

c x 927

c++ x 878

php x 692

html x 656