>A SQL like this will get the status but will omit the status having no entry:
>
>

>SELECT ExportDestination.Title,ExportStatus.Title_E,Temp.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
>INNER JOIN ExportStatus ON Temp.NoExportStatus=ExportStatus.Numero
>

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.