sql:
交叉连接
SELECT * FROM t_customer c,t_linkman l ;
内连接SELECT * FROM t_customer c,t_linkman l WHERE c.cid=l.clid;
隐式内连接
SELECT * FROM t_customer c INNER JOIN t_linkman l ON c.cid=l.clid;左外连接
SELECT * FROM t_customer c LEFT JOIN t_linkman l ON c.cid=l.clid;
右外连接
SELECT * FROM t_customer c RIGHT JOIN t_linkman l ON c.cid=l.clid;
hibernate:
交叉连接
List<Object[]> list=session.createQuery("select c from Customer c,LinkMan l).list();
内连接
List<Object[]> list=session.createQuery("select c from Customer c inner Join c.setLinkMan").list();
左外连接
List<Object[]> list=session.createQuery("select c from Customer c left Join c.setLinkMan").list();
右外连接
List<Object[]> list=session.createQuery("select c from Customer c outer Join c.setLinkMan").list();
迫切左外连接
List<Customer> list=session.createQuery("select distinct c from Customer c left Join fetch c.setLinkMan").list();
迫切内连接
List<Customer> list=session.createQuery("select distinct c from Customer c inner Join fetch c.setLinkMan").list();