This is doable but not very simple. The LEFT JOIN support is based on the fact that the outer table is before the inner table in the parsing order. You could probably parse RIGHT JOIN statements then reverse the order of the tables for join purposes. The data structure is an array of TableFilter objects created by Parser. The code you mention is the loop that performs the join. This should not be altered to support RIGHT JOIN.
In any case please upload the previous work you mentioned to the patch tracker for review. Fred ----- Original Message ----- From: "Marc de Hoop" <[EMAIL PROTECTED]> To: <hsqldb-developers@lists.sourceforge.net> Sent: 10 August 2005 11:44 Subject: [Hsqldb-developers] Right Join Hello list, We would like to add RIGHT JOIN support to HSQLDB. Could someone tell us how the current left join support works? We're mostly interested in knowing how hsqldb decides if a certain row is added to the query result in Select.buildResult (Select.java) and the meaning of the code in lines 819-858. yours, Marc de Hoop and Huug Ouwersloot. TOPdesk ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
