/* ServiceSupplier WAS this - okay */
SELECT *
FROM (SELECT tServiceType.ID AS ServiceTypeID, tServiceType.Code, tSupplier.ID AS SupplierID, tSupplier.SupplierName,
 tSystem.ID AS SystemID, tSystem.System, tBatchType.ID AS BatchTypeID, tBatchType.Description AS BatchTypeDescription,
 tValidAccountNumber.ID as ValidAccountNumberID, tValidAccountNumber.AccountNo
FROM (((tServiceType
INNER JOIN tSupplier ON tServiceType.SupplierID = tSupplier.ID)
INNER JOIN tSystem ON tServiceType.SystemID = tSystem.ID)
INNER JOIN tBatchType ON tBatchType.ID = tSystem.BatchTypeID)
LEFT JOIN tValidAccountNumber ON tBatchType.ID = tValidAccountNumber.BatchTypeID) AS SS
ORDER BY Code


/* Changed to this to try to ensure all service types are listed. */
SELECT *
FROM (SELECT tServiceType.ID AS ServiceTypeID, tServiceType.Code, tSupplier.ID AS SupplierID, tSupplier.SupplierName,
 tSystem.ID AS SystemID, tSystem.System, tBatchType.ID AS BatchTypeID, tBatchType.Description AS BatchTypeDescription,
 tValidAccountNumber.ID as ValidAccountNumberID, tValidAccountNumber.AccountNo
FROM (((tServiceType
LEFT JOIN tSupplier ON tServiceType.SupplierID = tSupplier.ID)
LEFT JOIN tSystem ON tServiceType.SystemID = tSystem.ID)
LEFT JOIN tBatchType ON tBatchType.ID = tSystem.BatchTypeID)
LEFT JOIN tValidAccountNumber ON tBatchType.ID = tValidAccountNumber.BatchTypeID) AS SS
ORDER BY Code