关键字: on:数据库在通过连接两张或多张表来返回记录时,都会生成一张中间的临时表,然后再将这张临时表返回给用户。
实例如下:
SELECT a.id AS ID,a.customer_key AS '推广员id',a.amount AS '金额', d.cooperation_code AS '合作点', e.total_amount AS '总收入',IF(e.amount='0' || e.amount is null,'已提现','未提现') AS '余额状态' FROM
rf_settlement_stat AS a
LEFT JOIN rf_promoter AS b ON a.customer_key = b.promoter_id
LEFT JOIN rf_balance AS e ON a.customer_key = e.customer_key
LEFT JOIN ql_cooperation_staff AS c ON c.jd_account = b.pin
LEFT JOIN ql_cooperation AS d ON d.cooperation_code = c.cooperation_code
WHERE a.tax_status='fini'
ORDER BY a.id ASC;
实例中级联了五个数据库表的查询,返回的数据中不管on条件是否满足,都是返回rf_settlement_stat表中的数据,最后通过where后的条件进行过滤后返回给用户&#x