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

转载于:https://www.cnblogs.com/bingege/archive/2012/04/13/2446226.html