# NAME SQL::Maker::Plugin::JoinSelect - Plugin of SQL::Maker for making SQL contained \`JOIN\` # SYNOPSIS use SQL::Maker; SQL::Maker->load_plugin('JoinSelect'); my $builder = SQL::Maker->new(driver => 'SQLite', new_line => ' '); my ($sql, @binds) = $builder->join_select( user => [ item => 'user.id = item.user_id', ], ['*'], { 'user.id' => 1, }, ); print $sql; #=> 'SELECT * FROM "user" INNER JOIN "item" ON user.id = item.user_id WHERE ("user"."id" = ?)'; # DESCRIPTION SQL::Maker::Plugin::JoinSelect is Plugin of SQL::Maker for making SQL contained \`JOIN\`. # INTERFACE ## Method ### `($sql, @binds) = $sql_maker->join_select($table, $join_conds, \@fields, \%where, \%opt)` `$table`, `\@fields`, `\%where` and `\%opt` are same as arguments of `$sql_maker->select`. `$join_conds` is an ArrayRef containing sequenced pair of `$table` and `$join_cond` as follows. [ 'user_item' => {'user.id' => 'user_item.user_id'}, 'item' => 'user_item.item_id => item.id', ... ] Each `$join_cond` can be ArrayRef, HashRef and String same as condition argument of [SQL::Maker::Select](http://search.cpan.org/perldoc?SQL::Maker::Select)'s `add_join` method. Join type is 'inner' by default. If you want to specify join type, you can use ArrayRef like follows. [ 'item' => ['outer' => {'user.id' => 'item.user_id'}], ] # LICENSE Copyright (C) Masayuki Matsuki. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. # AUTHOR Masayuki Matsuki