public void TestConditionWhereJoinWhere() { // Query Principal var sqlRaw = "select * from test"; var nsql = new NSQLQuery(sqlRaw); // Query 2 var nSubSql = new NSQLQuery(); nSubSql.Where("coluna1", Op.IGUAL, "TESTE"); // Adiciona sub query nsql.JoinWhere(nSubSql); var expected = "select * from test WHERE coluna1 = 'TESTE'"; Assert.AreEqual(expected, nsql.ToSql(), true); }