拱宸桥扛霸子的博客今天遇到一个数据库问题,A,B,C三表。需要从A表中查找部分数据select a.a1, a.a2 from A where ...从B中删除对应的数据,即删除select b.* from B b, (select a.a1, a.a2 from A where ...) awhere a.a1=b.b1 and ...
刘567的博客select * from v_instock where factory_id='123456' and (id,lot_no,shelfid) not in ( select ...用第二个参数查到的列作为not in 的条件 动态SQL: <select id="selectbyareaid" parameterType="string.