Revision 2728
Added by sgarg almost 19 years ago
AbstractDatabase.java | ||
---|---|---|
94 | 94 |
|
95 | 95 |
|
96 | 96 |
/** |
97 |
* Syntax for doing a left join |
|
98 |
* Add 'a.' in front of the fields for first table and |
|
99 |
* 'b.' in front of the fields for the second table |
|
100 |
* |
|
101 |
* @param selectFields fields that you want to be selected |
|
102 |
* @param tableA first table in the join |
|
103 |
* @param tableB second table in the join |
|
104 |
* @param joinCriteria the criteria based on which the join will be made |
|
105 |
* @param nonJoinCriteria all other criterias |
|
106 |
* @return return the string for teh select query |
|
107 |
*/ |
|
108 |
public abstract String getLeftJoinQuery(String selectFields, String tableA, |
|
109 |
String tableB, String joinCriteria, String nonJoinCriteria); |
|
110 |
|
|
111 |
/** |
|
97 | 112 |
* Instantiate a class using the name of the class at runtime |
98 | 113 |
* |
99 | 114 |
* @param className the fully qualified name of the class to instantiate |
Also available in: Unified diff
New function which returns the formatted left join query. This is required as Oracle and postgres have different left join syntax