Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE, COUNT(sr.snijpunt_reken_id)
- FROM snijpunt_reken sr
- WHERE sr.snijpunt_reken_id NOT IN(
- SELECT oe.snijpunt_id
- FROM onderwijsproduct_eisen oe
- )
- GROUP BY sr.dossier_id, sr.vaardigheid, sr.niveau, sr.TYPE
- HAVING COUNT (sr.snijpunt_reken_id)> 1
- ORDER BY sr.dossier_id, sr.TYPE, sr.vaardigheid, sr.niveau
- ## The ONLY thing missing ##
- IF there IS NO MATCH IN the "NOT IN" clause i can IGNORE the MIN(sr.snijpunt_reken_id) since the TABLE needs 1 VALUE BY DEFAULT.
- ## SOURCE ROWS
- snijpunt_reken_id dossier_id vaardigheid niveau TYPE
- 20158 2372 meten en meetkunde 3F MEIJERINK
- 16550 2372 meten en meetkunde 3F MEIJERINK
- 27032 2372 meten en meetkunde 3F MEIJERINK
- 9664 2372 meten en meetkunde 3F MEIJERINK
- 15755 367 verbanden 3F MEIJERINK
- 8825 367 verbanden 3F MEIJERINK
- 19363 367 verbanden 3F MEIJERINK
- 26237 367 verbanden 3F MEIJERINK
- # SOURCE IN JOIN TABLE
- product_id snijpunt_id weging leerjaar
- 79173 9664 4 1
- # Expected recordset after query
- snijpunt_reken_id dossier_id vaardigheid niveau TYPE
- 20158 2372 meten en meetkunde 3F MEIJERINK
- 16550 2372 meten en meetkunde 3F MEIJERINK
- 27032 2372 meten en meetkunde 3F MEIJERINK
- 15755 367 verbanden 3F MEIJERINK
- 8825 367 verbanden 3F MEIJERINK
- 19363 367 verbanden 3F MEIJERINK
- 26237 367 verbanden 3F MEIJERINK
- # ROWS that are currenly been selected but shouldnt
- 8825 (No RESULT WITH other TABLE AND MIN VALUE OF snijpunt_reken_id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement