>>If you need a report with all statuses for each destination, then first you need to do a cross join between statuses and destinations and the LEFT JOIN with the rest of your query (derived table).
>>
>>If you post relevant DDL and some insert statements and desired output, I'll post a query for you.
>
>Right now, my SQL is like this:
>
>

>SELECT ExportDestination.Title,ExportStatus.Title_E,COALESCE(Temp.CountRecord,0) AS CountRecord
>FROM
>(SELECT Export.NoExportStatus,Export.NoExportDestination,COUNT(*) AS CountRecord
> FROM Export (NOLOCK)
> GROUP BY Export.NoExportStatus,Export.NoExportDestination) Temp
>INNER JOIN ExportDestination ON Temp.NoExportDestination=ExportDestination.Numero
>RIGHT JOIN ExportStatus ON Temp.NoExportStatus=ExportStatus.Numero
>

>
>It gets a result like this:
>
>

>Title                 Title_E        CountRecord
>NULL                  Pending               0
>First destination     Completed         13209
>Second destination    Completed         13209
>NULL                  In progress           0
>NULL                  Calculated            0
>NULL                  Retry                 0
>

As I said, you first need a cross join between all destinations and Statuses. Once you have that, LEFT JOIN with the counts.

Is it clear?