cSmartSqlStatement::ScanJoinTable() - rstoetter/csmartsqlstatement-php GitHub Wiki

Method ScanJoinTable( )

 private   string rstoetter\cSmartSqlStatement\cSmartSqlStatement::ScanJoinTable(boolean $scanfortablename)

The method ScanJoinTable( ) scans the actual query string and returns the next join table which is in the buffer

join_table: table_reference [INNER | CROSS] JOIN table_factor [join_condition] | table_reference STRAIGHT_JOIN table_factor | table_reference STRAIGHT_JOIN table_factor ON conditional_expr | table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_condition | table_reference NATURAL [{LEFT|RIGHT} [OUTER]] JOIN table_factor

Example:

Arguments

  • $scanfortablename boolean - <p>if true, then ScanJoinTable( ) tries first to read a table name. It defaults to true.</p>

Returns

string the join table or an empty string