INNER JOINã¨OUTER JOIN - 紳士ãªãƒ–ãƒã‚°æœ€è¿‘ã€SQL文を直接書ã機会ãŒã‚ã£ã¦ã€ä»Šã¾ã§ã»ã¨ã‚“ã©å…¨ãSQLã«ã¤ã„ã¦å‹‰å¼·ã™ã‚‹æ©Ÿä¼šãŒãªã‹ã£ãŸã®ã§æ¥å‹™ã«é–¢ä¿‚ã®ã‚ã‚‹ã¨ã“ã‚ã‚’å°‘ã—ã‹ã˜ã£ã¦ã¿ã‚‹ã“ã¨ã«ã€‚ 今ã¾ã§ã„ã‹ã«ActiveRecord先生ã«ãŠä¸–話ã«ãªã£ã¦ã„ãŸã‹ãŒã‚ˆãã‚ã‹ã‚Šã¾ã—ãŸã€‚ ã•ã¦ã•ã¦ã€ãã‚Œã§ã¯æœ¬é¡Œã€‚ INNER JOINã¨OUTER JOINã®é•ã„ã«ã¤ã„ã¦ç†è§£ã‚’æ·±ã‚ã¦ã„ãã¾ã™ã€‚ 以下ã®ãƒ†ãƒ¼ãƒ–ルã«å¯¾ã—ã¦SQLを発行ã—ã¦ãã®çµæžœã‚’見ã¦ã„ãã“ã¨ã«ã—ã¾ã™ã€‚ mysql> select * from dogs; +----+-------+----------+ | id | name | owner_id | +----+-------+----------+ | 1 | aka | 1 | | 2 | ao | 2 | | 3 | shiro | 1 | | 4 | kuro | 4 | +----+-------+----------+
åŒã˜ãƒ†ãƒ¼ãƒ–ルをçµåˆã™ã‚‹(自己çµåˆ)
ã¯ã¦ãªãƒ–ãƒã‚° | 無料ブãƒã‚°ã‚’作æˆã—よã†
{{#tags}}- {{label}}
{{/tags}}