SQL2000下的三表查询

SELECT *
FROM ZdMx INNER JOIN
      CargoInfo ON ZdMx.CargoNo = CargoInfo.BH INNER JOIN
      CargoTypeInfo ON CargoInfo.NumOfType = CargoTypeInfo.ID
WHERE (ZdMx.ZdHzNo = 'XF20120411000007')
ORDER BY ZdMx.ZdHzNo