web | Java

请把下面的HQL语句改为其他方式实现

千锋教育

1)请优化: select a.key,a.value from a where a.key not in (select b.key from b) 

2)已优化: select t1.key,t1.value from ( select a.key,a.value from a ) t1 right join ( select b.key from b ) t2 on t1.key = t2 .key where t1.key is null;  


3)请优化: select a.key,a.value from a where a.key in (select b.key from b) 


4)已优化: select t1.key,t1.value from ( select a.key,a.value from a ) t1 join ( select b.key from b ) t2 on t1.key = t2 .key;