JOIN ON predicate must start with "ON" keyword'

[pengshaomin]

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'