On 2010.04.29 5:06 PM, André Knappstein, Controlling wrote:
> k> select userinfo0_.id as x0_0_
> k> from user_infos userinfo0_
> k> where (@p0 in(select views1_.View_Id from User_Views_Map views1_
> k> where userinfo0_.id=views1_.User_Id))
>
try this
select userinfo0_.id as x0_0_
from user_infos userinfo0_
where exists (select 1 from User_Views_Map views1_
where userinfo0_.id=views1_.User_Id and views1_.view_...@p0)
Regards
Paul
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
