随笔分类 -  数据库

摘要：select b.org_code,b.field_id from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.field_id is not null; select b.org_code from T_DIAG_DETAIL_ 阅读全文

摘要：select a from A a,B b where a.t=b.tselect a from A a where a.t in (select b.t from B b)select distinct a.org_code,a.org_name from t_ORGANZATION a,T_DM 阅读全文