![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
多表联合查询
勤读意现
我希望自己更强大
展开
-
hibernate多表联合查询
//三表联合查询 /* * select t.* from product t,category c,categorysecond cs WHERE t.csid = cs.csid and c.cid = cs.cid and c.cid = 1 */原创 2016-06-30 07:22:54 · 1260 阅读 · 0 评论 -
mysql+mybatis 外连接拼接字段--gxy
<select id="queryInfo" resultMap="BaseCustomerResultMap"> select t.*, c.num,c.communicateTime from t_baseimportcustom t LEFT JOIN ( SELECT tt.baseId,原创 2017-12-26 18:14:17 · 604 阅读 · 0 评论 -
oracle存储过程跟函数的应用实例,复杂查询并赋值--------------------------------gxy
function getSql(Clpfbh1 varchar2,Clpfbh2 varchar2,Clpfbh3 varchar2,Clpfbh4 varchar2) return varchar2 is sqlDeal varchar2(3000) := 'create or replace view xmxxdb_v as '; sqlgroupby number :...原创 2018-09-21 08:52:44 · 583 阅读 · 0 评论