You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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(...));
  • No labels