left outer join??????createFromJoinElement????
Posted by ~Ray @ 2007-10-28 12:08:34
- 浏览帖子内容 (主题:2208 帖子:10377) []本版斑竹: 当前位置: >> >>
主题:left outer join怎样使用?报createFromJoinElement时候出错(回复数:0作者:)
HQL如下：----------------------------------------------------------select new enumerate(u userid,u username,f familyid)from Userinfo u,Familyinfo f left outer join f familyidwhere u username = :username and u userpsd = :password and u familyid = f familyid-----------------------------------------------------------Userinfo和Familyinfo是两个表，两个表没有任何约束。Userinfo的PK是userid. Userinfo含有familyid字段。Familyinfo的PK是familyid如果Userinfo表只有一条数据，Familyinfo没有数据，我想得出的结果是"id","name",null请问我该如何写HQL？还需要注意什么？谢谢[ADVERTHERE]Related article:
http://www.matrix.org.cn/thread.shtml?topicId=f5b8d942-5950-11dc-a449-51bb371715aa&forumId=23
0 Comments:
No comments have been posted yet!
|
