int userId SqlQuery tmpObjSelect new Select From NtrTradeGroupXUser Wh

int userId = 1;


SqlQuery tmpObjSelect = new Select().From<NtrTradeGroupXUser>()
                                .Where(NtrTradeGroupXUser.Columns.TradeGroupId).
                                    In(
                                        new Select(NtrTradeGroup.Columns.Id).From<NtrTradeGroup>()
                                        .Where(NtrTradeGroup.Columns.OwnerUserId).IsEqualTo(userId)
                                        )
                                 .And(NtrTradeGroupXUser.Columns.IsApproved).IsEqualTo(0);