DataFaucet ORM


The select object has a union() method to allow you to create SQL union statements. The object created by union() is simply another Select object with all the same properties and methods.

The most important arguments to the join method are these:

tablen/aThe related table to union
columnsn/aa list of columns to return in the union table - remember that columns in each union statement must match
alln/aboolean - if true overrides the default union behavior of removing duplicates and allows you to see any duplicted entries in the results


  // get the datasource
  ds = request.DataFaucet.getDatasource(); 
  // get a select statement 
  stmt = ds.getSelect("productname,productprice","tblProduct"); 
  // union the archived products table 
  // get the results