Reportico / Sql union query

Question

I got a problem with a query while using Union.

I use the following query to get my result:

SELECT substr(directory_vis,locate(":", directory_vis) +1, (locate(">>", directory_vis) - locate(":", directory_vis) -1)) as dossier, count(doc_id) as aantal_documenten
FROM openims_algemeen_document_data
WHERE 1=1
GROUP BY dossier

UNION 

SELECT substr(directory_vis,locate(":", directory_vis) +1, (locate(">>", directory_vis) - locate(":", directory_vis) -1)) as dossier, count(doc_id) as aantal_documenten
FROM postin_document_data
WHERE 1=1
GROUP BY dossier

UNION

SELECT substr(directory_vis,locate(":", directory_vis) +1, (locate(">>", directory_vis) - locate(":", directory_vis) -1)) as dossier, count(doc_id) as aantal_documenten
FROM qualdoc_document_data
WHERE 1=1
GROUP BY dossier
ORDER BY dossier

I need to have all the "dossiers" from multiple tables. The problem that I have here is that I get duplicate records. Because the same "dossier" can be in multiple tables.

How can I fix this?