以下是我SQL敘述,請問各位大賢,如何下MoDetail.DateID條件但所有Kind.KindID都要出來----------------------------------------------------------------------------------------------------
SELECT Kind.KindID, Kind.KindName, MoDetail.GoodsID, Goods.GoodsName1,MoDetail.Remark, MoDetail.SupID, MoDetail.OrdID, MoDetail.DateID
FROM MoDetail INNER JOIN
Goods ON MoDetail.GoodsID = Goods.GoodsID RIGHT OUTER JOIN
Kind ON Goods.KindID = Kind.KindID