pengshaomin

JOIN ON predicate must start with "ON" keyword'

1

Like the case: SELECT count(*) FROM TB_JD_ORDER A WITH(NOLOCK) INNER JOIN TB_JD_ORDER_DETAIL B WITH(NOLOCK) ON A.F_ID = b.F_MID LEFT JOIN TB_PRODUCT_ATTRIBUTE att On att.F_ID = B.F_SYS_PRODUCT_ID WHERE a.F_BILL_DATE >= '2019-08-03'