忘了一点这中不家一表与Tb_A 关联……。 是三个表就不会用左联接了。我是这么写的 FROM Tb_A A inner join Tb_B B left join Tb_C C on A.Clientid=B.id and A.cityid=C.id WHERE H.TheDate BETWEEN '2005-7-1' AND '2005-8-1'
SELECT H.TheDate,C.City,H.MainBill,H.MinorBill,H.Pieces,H.Weight,H.FreightRate, H.FreightCharge,H.DeliverRate,H.DeliverCharge,H.GoodsName,T.name,H.ID FROM Tb_HLContrastBill H inner join Tb_City C on H.cityid=C.id left join Tb_Client T on H.ClientID=T.id WHERE H.TheDate BETWEEN '2005-7-1' AND '2005-8-1' ORDER BY H.ID DESC这么写就对了 我知道了。 我刚才彪了一下,太笨了。不好意思。现在坦白。 :)
FROM Tb_A A inner join Tb_B B left join Tb_C C on A.Clientid=B.id
and A.cityid=C.id WHERE H.TheDate
BETWEEN '2005-7-1' AND '2005-8-1'
H.FreightCharge,H.DeliverRate,H.DeliverCharge,H.GoodsName,T.name,H.ID
FROM Tb_HLContrastBill H inner join Tb_City C
on H.cityid=C.id left join Tb_Client T
on H.ClientID=T.id WHERE H.TheDate
BETWEEN '2005-7-1' AND '2005-8-1' ORDER BY H.ID DESC这么写就对了 我知道了。 我刚才彪了一下,太笨了。不好意思。现在坦白。 :)