THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
These are examples taken from the mailing list.
How do I write sub-select queries?
// Define the sub query DBCommand subCmd = db.createCommand(); subCmd.select(...); // Wrap command for subquery DBQuery SQ = new DBQuery(subCmd); // Define the main query DBCommand cmd = db.createCommand(); cmd.select(..); cmd.select(SQ.findQueryColumn(...)); cmd.join(..., SQ.findQueryColumn(...));