access 的多个left join 要加括号
摘要:
string sql = "select a.orderId,a.UserName,b.CodeValue as Delivery ,a.DeliveryAddress,a.PhoneNum,c.CodeValue as Payment,d.CodeValue as OrderStatus,d.CodeValue as OrderStatusID,a.OrderTime,a.Merchant from (( m_Order a "; sql += " left join ( select CodeId,CodeValue from M_DefaultValue w 阅读全文
posted @ 2009-11-19 15:41 风乔 阅读(394) 评论(0) 推荐(0) 编辑