常用SQL

1，
select * from com left join (select * from lang where expir_date = '99999999' and abolit_date is null) lang on com.cust_cd = lang.cust_cd where com.expir_date = '99999999' and com.abolit_date is null