SELECT a.* FROM auctioncommendity a
LEFT JOIN auctionbid b
ON a.id=b.auctioncommendityid AND a.id='000000004ef2f390014ef3024f230015';
对于这条SQL,会出现第一条条件筛选无效,原因是因为对于left jion ,不管on后面的是什么条件,左表都会全部查出来,要想要实现条件查询,就得使用WHERE 来限制
SELECT a.* FROM auctioncommendity a
LEFT JOIN auctionbid b
ON a.id=b.auctioncommendityid WHERE a.id='000000004ef2f390014ef3024f230015';