>You need to start from ExportStatus table and LEFT JOIN with the rest of your query.
>
>

>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

-- use RIGHT JOIN to get all statuses from ExportStatus.

This gets better, but as you mentioned in the other message, it doesn't get it all. I will follow in this other message.