mysql查询在一个表而不在另一个表中的数据

select C.company_name,C.company_address from Companylist C left join "company_LoAndLa" L on C.company_name=L.company_name where L.company_name is null

其他两种写法：

select distinct A.ID from A where A.ID not in (select ID from B)


速度最快：
select * from B where (select count(1) as num from A where A.ID = B.ID) = 0