in desperation I use the following script, perhaps the master anyone want to add? This script really takes a long time to process the results...

SELECT

rj_poliklinik.nmpoli as namapoli,count (rj_reg.noreg) as jumpasien,rj_reg.kdperusahaan...

if i use union all the result like this

Msg 205, Level 16, State 1, Line 1

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number...

i'm sorry master...but it said

Msg 1033, Level 15, State 1, Line 13

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP...

i'm sorry master...the output look like this

Nama Poli | Jum | Kd.Instansi | Nama Instansi | Karcis | Tindakan | ALKES |

i'm sorry master...the output look likethis

No. Nama Poli | Jum | Kd.Instansi | Nama Instansi | Karcis | Tindakan | ALKES |