Als ik deze query uitvoer krijg ik dubbele waardes te zien terwijl ik distinct gebruik. Weet iemand van jullie hoe dat komt en hoe ik de waardes juist kan distincten of beperken?
dit is mij query
SELECT DISTINCT train.id AS id, afd.id AS afdeling_id, subaf.id AS subafdeling_id, cat.id AS Categorie_is, subcat.id AS Subcategorie_id, typ.id AS Type_id
FROM training train
JOIN training_afdeling train_afd ON train_afd.training_id = train.id
JOIN afdeling afd ON afd.id = train_afd.afdeling_id
JOIN training_subafdeling train_subaf ON train_subaf.training_id = train.id
JOIN subafdeling subaf ON subaf.id = train_subaf.subafdeling_id
JOIN training_categorie train_cat ON train_cat.training_id = train.id
JOIN categorie cat ON cat.id = train_cat.categorie_id
JOIN training_subcategorie train_subcat ON train_subcat.training_id = train.id
JOIN subcategorie subcat ON subcat.id = train_cat.categorie_id
JOIN training_type train_typ ON train_typ.training_id = train.id
JOIN type_training typ ON typ.id = train_typ.type_id
WHERE train.id = '2'
ORDER BY train.naam_training
1.003 views
