再求教一条SQL语句,谢谢了!
SELECT PoundMaterial.vMaterialName AS 货名, PoundIntOutUnit.vUnitName AS 发货方,
ShouHuoFang.vUnitName AS 收货方, PoundType.vTypeName AS 装货方,
Operator.vUserName AS 称毛重, ChengPiZhong.vUserName AS 称皮重,
PoundRecord.vRecoreId AS 磅单号, PoundRecord.vCarNo AS 车号,
PoundRecord.SkinDate AS 毛重日期, PoundRecord.SkinTime AS 毛重时间,
PoundRecord.dDate AS 皮重日期, PoundRecord.dTime AS 皮重时间,
PoundRecord.nGrossWei AS 毛重, PoundRecord.nSkin AS 皮重,
PoundRecord.nNetWei AS 净重
FROM PoundRecord LEFT OUTER JOIN
Operator ON Operator.vUserId = PoundRecord.vEmployeeId LEFT OUTER JOIN
PoundMaterial ON
PoundMaterial.vMaterialId = PoundRecord.vMaterialId LEFT OUTER JOIN
PoundType ON
PoundType.vMatTypeId = PoundRecord.vMatTypeId LEFT OUTER JOIN
PoundIntOutUnit ON
PoundIntOutUnit.vUnitId = PoundRecord.vOutUnitId LEFT OUTER JOIN
PoundIntOutUnit ShouHuoFang ON
ShouHuoFang.vUnitId = PoundRecord.vInUnitId LEFT OUTER JOIN
Operator ChengPiZhong ON
ChengPiZhong.vUserId = PoundRecord.vSkinOperator
WHERE (PoundRecord.vCarNo = 00852) AND (PoundRecord.SkinDate BETWEEN '2005-10-1' AND '2005-11-1')
ORDER BY PoundRecord.vRecoreId
上面的语句完全正确,但我要加个查询条件:PoundRecord.vOutUnitId = '红星煤矿',但PoundRecord.vOutUnitId字段是引用PoundIntOutUnit.vUnitId的,是个代号,就是说它两相等,实际PoundIntOutUnit.vUnitName才保存我要的:红星煤矿。请问我如何写这条SQL语句?