| SE_queryinfo_set_tables | |
Sets the tables for a query
LONG SE_queryinfo_set_tables
(SE_QUERYINFO query_info,
const LONG num_tables,
const CHAR **tables,
const CHAR **aliases);
| query_info | The SE_QUERYINFO handle |
| num_tables | The number of tables |
| tables | A pointer to a list of table names |
| aliases | A pointer to a list of aliases for the tables |
SE_queryinfo_set_tables sets the tables for a query. The order in the tables parameter define the order that the tables will appear in the FROM portion of the table join. You can qualify the table names with <owner>.table. You can also set table aliases for table joins to resolve ambiguities in the SELECT columns and WHERE clause of the join. Table aliases are optional and are only applied to the FROM clause of the SQL query expression.
SE_SUCCESS
SE_FAILURE
SE_INVALID_PARAM_VALUE
SE_INVALID_POINTER
SE_INVALID_QUERYINFO_OBJECT
SE_NET_FAILURE
SE_OUT_OF_CLMEM
SE_SDE_NOT_STARTED