Metacat

  /**

   * The Oracles's syntax for doing a left join

   * Add 'a.' in front of the fields for first table and

   * 'b.' in front of the fields for the second table

   * 

   * @param selectFields fields that you want to be selected

   * @param tableA first table in the join

   * @param tableB second table in the join

   * @param joinCriteria the criteria based on which the join will be made

   * @param nonJoinCriteria all other criterias

   * @return return the string for teh select query

   */

  public String getLeftJoinQuery(String selectFields, String tableA, 

		  String tableB, String joinCriteria, String nonJoinCriteria){

	  return "SELECT " + selectFields + " FROM " + tableA + " a, " 

	         + tableB + " b WHERE " + joinCriteria + "(+) " + " AND (" 

	         + nonJoinCriteria +")";

  }