SQL查询问题。

SQL code:

strListSql = "SELECT Money.ID AS Money_ID,Money.CustomNO AS Custom_NO,Custom.SeriesType as Custom_Flag,Custom.M_Name as Custom_M_Name,"
strListSql = strListSql & " Custom.F_Name AS Custom_F_Name, Custom.Series AS Custom_Series,"
strListSql = strListSql & " Custom.SeriesPrice AS Custom_SeriesPrice,"
strListSql = strListSql & " Money.Date AS Money_Date, Money.Shroff AS Money_Shroff,Money.CustomType AS Money_CustomType,"
strListSql = strListSql & " Money.Type As Money_Type,Money.PayType AS Money_PayType, Money.Money AS Money_Money, Money.Remark AS Money_Remark "
strListSql = strListSql & " from Custom LEFT JOIN Money ON Custom.CustomNO=Money.CustomNO "
strListSql = strListSql & " ORDER BY Money.Date DESC"




有上面的一段SQL，这样列出来是没问题的，但是后来发现系统入帐列不出来，原来是系统入帐没有相庆的CustomNO，怎么样才能列出来，列为表中的“Remark”值为"系统入帐"。主要是" from Custom LEFT JOIN Money ON Custom.CustomNO=Money.CustomNO "这个地方，怎么样加一个，能单独把Money.Remark="系统入帐"的也列出来.谢谢。

---

ON Custom.CustomNO=Money.CustomNO or Money.Remark='系统入帐'

---

不过这样Money.Remark='系统入帐'和Custom的记录怎么对应？

---

不是。主要问题是系统入