• 查询语言.join
    • 函数原型
    • $mixTable 和 $mixCols 与 table 方法中的用法一致
    • $mixCond 与 where 方法中的用法一致
    • innerJoin 与 join 一致
    • leftJoin
    • rightJoin
    • fullJoin
    • crossJoin
    • naturalJoin

    查询语言.join

    函数原型

    1. public function join($mixTable, $mixCols = '*', $mixCond /* args */);

    $mixTable 和 $mixCols 与 table 方法中的用法一致

    1. # SELECT `test`.*,`hello`.`name`,`hello`.`value` FROM `test` INNER JOIN `hello` ON `test`.`name` = '小牛'
    2. Db::table('test')->
    4. join('hello', 'name,value', 'name', '=', '小牛')->
    6. getAll();
    8. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` INNER JOIN `hello`  `t` ON `test`.`name` = '小牛' 
    9. Db::table('test')->
    11. join(['t' => 'hello'], ['name as nikename', 'tt' => 'value'], 'name', '=', '小牛')->
    13. getAll();

    $mixCond 与 where 方法中的用法一致

    去掉前面两个参数，后面的全部都是条件参数。

    1. # SELECT `test`.*,`hello`.`name`,`hello`.`value` FROM `test` INNER JOIN `hello` ON `test`.`hello` = 'world' AND `test`.`test` > `test`.`name`
    2. Db::table('test')->
    4. join('hello', 'name,value', ['hello' => 'world', ['test', '>', '{[name]}']])->
    6. getAll();
    8. # SELECT `test`.*,`hello`.`name`,`hello`.`value` FROM `test` INNER JOIN `hello` ON (`hello`.`id` < 5 AND `hello`.`name` LIKE 'hello')
    9. Db::table('test')->
    11. join('hello', 'name,value', function ($select) {
    12.     $select->where('id', '<', 5)->where('name', 'like', 'hello');
    13. }s)->
    15. getAll();

    innerJoin 与 join 一致

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` INNER JOIN `hello`  `t` ON `t`.`name` = '小牛'
    2. Db::table('test')->
    4. innerJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'], 'name', '=', '小牛')->
    6. getAll();

    leftJoin

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` LEFT JOIN `hello`  `t` ON `t`.`name` = '小牛'
    2. Db::table('test')->
    4. innerJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'], 'name', '=', '小牛')->
    6. getAll();

    rightJoin

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` RIGHT JOIN `hello`  `t` ON `t`.`name` = '小牛'
    2. Db::table('test')->
    4. rightJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'], 'name', '=', '小牛')->
    6. getAll();

    fullJoin

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` FULL JOIN `hello`  `t` ON `t`.`name` = '小牛'
    2. Db::table('test')->
    4. fullJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'], 'name', '=', '小牛')->
    6. getAll();

    crossJoin

    交叉连接不用设置 on 条件。

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` CROSS JOIN `hello`  `t`
    2. Db::table('test')->
    4. crossJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'])->
    6. getAll();

    naturalJoin

    自然连接不用设置 on 条件。

    1. # SELECT `test`.*,`t`.`name` AS `nikename`,`t`.`value` AS `tt` FROM `test` NATURAL JOIN `hello`  `t`
    2. Db::table('test')->
    4. naturalJoin(['t' => 'hello'], ['name as nikename', 'tt' => 'value'])->
    6. getAll();