左表数据10000条,右表数据2500条,左表datee对应右表唯一datee,通过左连接获取对应orderid的year;左连接后为null。
select stock.orderid,sdate.year from stock left join sdate on stock.datee=sdate.datee limit 10;
结果
+---------+------+
| orderid | year |
+---------+------+
| 009999 | 2017 |
| 000000 | NULL |
| 000001 | NULL |
| 000002 | NULL |
| 000003 | NULL |
| 000004 | NULL |
| 000005 | NULL |
| 000006 | NULL |
| 000007 | NULL |
| 000008 | NULL |
+---------+------+