select_join_targets


Description:

[ Version ( since = "4.2" ) ]
public SqlBuilderId select_join_targets (SqlBuilderId left_target_id, SqlBuilderId right_target_id, SqlSelectJoinType join_type, SqlBuilderId join_expr)

Joins two targets in a SELECT statement, using the join_type type of join.

Note: if the target represented by left_target_id is actually situated after (on the right) of the target represented by right_target_id, then the actual type of join may be switched from gda_sql_select_join_left to gda_sql_select_join_right or from gda_sql_select_join_right to gda_sql_select_join_left.

Parameters:

this

a SqlBuilder object

left_target_id

the ID of the left target to use (not 0)

right_target_id

the ID of the right target to use (not 0)

join_type

the type of join

join_expr

joining expression's ID, or 0

Returns:

the ID of the new join, or 0 if there was an error