"    <column name='Id' type='INTEGER' primaryKey='true'/>\n"+
"    <column name='Id' type='INTEGER' primaryKey='true' required='true'/>\n"+
    public void testJoinQuery() throws Exception    {        createDatabase(            "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+            "<database name='ddlutils'>\n"+            "  <table name='TestTable1'>\n"+            "    <column name='Id1' type='INTEGER' primaryKey='true'/>\n"+            "    <column name='Id2' type='INTEGER'/>\n"+            "  </table>\n"+            "  <table name='TestTable2'>\n"+            "    <column name='Id' type='INTEGER' primaryKey='true'/>\n"+            "    <column name='Avalue' type='VARCHAR' size='15'/>\n"+            "  </table>\n"+            "</database>");        insertData(            "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+            "<data>\n"+            "  <TestTable1 Id1='1'/>\n"+            "  <TestTable1 Id1='2' Id2='3'/>\n"+            "  <TestTable2 Id='1' Avalue='Text 1'/>\n"+            "  <TestTable2 Id='2' Avalue='Text 2'/>\n"+            "  <TestTable2 Id='3' Avalue='Text 3'/>"+            "</data>");        ModelBasedResultSetIterator it   = (ModelBasedResultSetIterator)getPlatform().query(getModel(), "SELECT Id1, Avalue FROM TestTable1, TestTable2 WHERE Id2 = Id");        DynaBean        bean = null;        assertTrue(it.hasNext());        bean = (DynaBean)it.next();        assertEquals(new Integer(2),                     getPropertyValue(bean, "Id1"));        assertEquals("Text 3",                     getPropertyValue(bean, "Avalue"));        assertFalse(it.hasNext());        assertFalse(it.isConnectionOpen());    }