HnD | How to construct subquery in where clause, Page 1

How to construct subquery in where clause

Posts

ratjetoes
User

Posts: 4
Joined: 06-Aug-2009

# Posted on: 14-Sep-2009 14:08:53

Hi,

I would like to write the following query in LLBLGen:

SELECT t.ID FROM Test t WHERE (t.IS_CONDITION = 0 OR t.ID IN (SELECT s.ID FROM SUBQUERY s WHERE s.IS_CONDITION_2 = 1)

Anyone any idea?

T.i.a., ratjetoes.

Walaa
Support Team

Posts: 14993
Joined: 21-Aug-2005

# Posted on: 14-Sep-2009 16:00:41

Please check the docs for FieldCompareSetPredicate