$sqldb->dbms_join_on_unsupported() : 1
Capability Limitation: This driver does not support the join ... on ... syntax.
$sqldb->dbms_outer_join_unsupported() : 1
Capability Limitation: This driver does not support any type of outer joins.
sql_join() $sqldb->sql_join( $table1, $table2, ... ) : $sql, @params $sqldb->sql_join( $table1, \%criteria, $table2 ) : $sql, @params $sqldb->sql_join( $table1, $join_type=>\%criteria, $table2 ) : $sql, @params
Processes one or more table names to create the from clause of a select statement. Table names may appear in succession for normal cross joins, or you may specify a join criteria between them.
Inner joins are replaced with normal comma cross joins and a where clause. Use of a left, right or full outer join causes an exception to be thrown.
Note that using join criteria will cause the return from this method to be a bit different than that of the superclass; instead of just being a from expression with table names, the returned SQL statement will also include a where expression. Conveniently, the sql_where method allows post-processing of a statement that already includes a where clause, so this value can still be combined with additional criteria supplied as a separate where argument to one of the select methods.
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.
|perl v5.20.3||SQLENGINE::DRIVER::TRAIT::NOCOMPLEXJOINS (3)||2004-11-07|