public void JoinWithSubquery() { var result = Execute("SELECT a.name, b.code FROM persons a, (SELECT * FROM codes) b WHERE a.person_id = b.person_id"); Assert.IsNotNull(result); Assert.AreEqual(2, result.RowCount); }