Hi all,

Can someone please help me with this particular peace of sql code that i need to write in LLBL:

select * from myTable t where exists (select null from myOtherTable ot where t.nonKeyColumn = ot.nonKeyKolumn and t.nonKeyColumn2 = ot.nonKeyKolumn2 and t.nonKeyColumn3 = ot.nonKeyKolumn3)

I found some code samples on that matter, but none of those i could use directly, and I have hard time figuring it out myself.

Thanks in advance, V

Isn't this exactly the same as a simple Join.

If you still want to use the Exists clause, then please check FieldCompareSetPredicate

Thank you for such a quick answer.

You are absolutely right, I didn't gave you exact query, in which where clause is quite a bit more complex then the one I posted.

I've already seen the link you've posted, but something bothered me, it looks like you have to name one column as first parameter, and I can not provide it, because key column is not of any importance to the query I intend to execute.

I would be grateful if you could provide me with code sample for the problem I described in first post.

Cheers, V

Naming a column won't make a difference in the resultSet. As the Outer Selected Entity is the one which will be returned.

That's the one

Works like charm now, thanks.

Guys,

I could use some more help on this one.

in FieldCompareSetPredicate i need to add predicate which checks if value of one field contains value of another ( both fields are of type string )

SQL code would be something like: ...AND field1 like field2 + '%'

Any ideas?

You need to have a look at FieldExpressions http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_expressionsaggregates.htm#expressions which are designed expressly to do this sort of field manipulation and comparisons.

Matt