{"id":6413,"date":"2026-03-06T14:04:02","date_gmt":"2026-03-06T05:04:02","guid":{"rendered":"https:\/\/route-zero.com\/recruit\/?post_type=route&#038;p=6413"},"modified":"2026-10-06T14:04:11","modified_gmt":"2026-10-06T05:04:11","slug":"sql-left-join-where-on-condition","status":"publish","type":"route","link":"https:\/\/route-zero.com\/recruit\/route\/6413\/","title":{"rendered":"LEFT JOIN\u3067\u884c\u304c\u6d88\u3048\u308b\uff1fWHERE\u6761\u4ef6\u306e\u898b\u76f4\u3057\u65b9"},"content":{"rendered":"<p>LEFT JOIN\u3092\u4f7f\u3063\u305f\u306e\u306b\u5de6\u5074\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u304c\u6d88\u3048\u308b\u5834\u5408\u3001\u53f3\u5074\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u3092`WHERE`\u306b\u66f8\u3044\u3066\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002LEFT JOIN\u3067\u4e00\u81f4\u3057\u306a\u304b\u3063\u305f\u884c\u306f\u53f3\u5074\u306e\u5217\u304cNULL\u306b\u306a\u308a\u307e\u3059\u3002\u305d\u306e\u5f8c\u306b`WHERE right.status = &#39;ACTIVE&#39;`\u306e\u3088\u3046\u306a\u6761\u4ef6\u3092\u304b\u3051\u308b\u3068\u3001NULL\u306e\u884c\u306f\u6761\u4ef6\u3092\u6e80\u305f\u3055\u305a\u9664\u5916\u3055\u308c\u307e\u3059\u3002\u300c\u5de6\u5074\u306e\u884c\u306f\u6b8b\u3057\u3001ACTIVE\u306e\u53f3\u5074\u884c\u3060\u3051\u7d50\u5408\u3057\u305f\u3044\u300d\u306a\u3089\u3001\u305d\u306e\u6761\u4ef6\u3092`ON`\u5074\u3078\u7f6e\u304f\u306e\u304c\u57fa\u672c\u3067\u3059\u3002<\/p>\n<h2>\u307e\u305a\u7d50\u8ad6\uff1a\u53f3\u8868\u306e\u6761\u4ef6\u3092WHERE\u306b\u7f6e\u304f\u3068\u672a\u4e00\u81f4\u884c\u304c\u6d88\u3048\u308b<\/h2>\n<table>\n<thead>\n<tr>\n<th>\u66f8\u304d\u65b9<\/th>\n<th>\u5de6\u8868\u306e\u672a\u4e00\u81f4\u884c<\/th>\n<th>\u610f\u5473<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>LEFT JOIN &#8230; ON &#8230; WHERE right.status = &#39;ACTIVE&#39;<\/td>\n<td>\u6d88\u3048\u308b<\/td>\n<td>JOIN\u5f8c\u306e\u7d50\u679c\u304b\u3089ACTIVE\u4ee5\u5916\u3092\u9664\u5916\u3059\u308b<\/td>\n<\/tr>\n<tr>\n<td>LEFT JOIN &#8230; ON &#8230; AND right.status = &#39;ACTIVE&#39;<\/td>\n<td>\u6b8b\u308b<\/td>\n<td>ACTIVE\u306e\u53f3\u884c\u3060\u3051\u3092\u7d50\u5408\u5bfe\u8c61\u306b\u3059\u308b<\/td>\n<\/tr>\n<tr>\n<td>INNER JOIN &#8230; ON &#8230; AND right.status = &#39;ACTIVE&#39;<\/td>\n<td>\u6d88\u3048\u308b<\/td>\n<td>\u4e00\u81f4\u3059\u308bACTIVE\u884c\u3060\u3051\u304c\u5fc5\u8981\u306a\u5834\u5408<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>PostgreSQL\u306e\u73fe\u884c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u3082\u3001LEFT OUTER JOIN\u306f\u4e00\u81f4\u3057\u306a\u3044\u5de6\u5074\u884c\u3092\u53f3\u5217NULL\u3067\u8ffd\u52a0\u3057\u3001\u305d\u306e\u5f8cWHERE\u306fFROM\u53e5\u3067\u4f5c\u3089\u308c\u305f\u7d50\u679c\u3078\u9069\u7528\u3055\u308c\u307e\u3059\u3002WHERE\u306e\u6761\u4ef6\u7d50\u679c\u304cfalse\u307e\u305f\u306fNULL\u306a\u3089\u3001\u305d\u306e\u884c\u306f\u9664\u5916\u3055\u308c\u307e\u3059\u3002<\/p>\n<hr>\n<h2>\u3088\u304f\u3042\u308b\u5931\u6557\uff1a\u53f3\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u3092WHERE\u3078\u66f8\u304f<\/h2>\n<p>\u30e6\u30fc\u30b6\u30fc\u4e00\u89a7\u306b\u3001ACTIVE\u306a\u6ce8\u6587\u304c\u3042\u308c\u3070\u7d50\u5408\u3057\u305f\u3044\u4f8b\u3092\u8003\u3048\u307e\u3059\u3002\u6b21\u306eSQL\u3067\u306f\u3001\u6ce8\u6587\u304c\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3084ACTIVE\u3067\u306f\u306a\u3044\u6ce8\u6587\u3057\u304b\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u304c\u7d50\u679c\u304b\u3089\u6d88\u3048\u307e\u3059\u3002<\/p>\n<pre><code>SELECT\r\n    u.id,\r\n    u.name,\r\n    o.id AS order_id\r\nFROM users u\r\nLEFT JOIN orders o\r\n    ON o.user_id = u.id\r\nWHERE o.status = &#39;ACTIVE&#39;;<\/code><\/pre>\n<p>LEFT JOIN\u3067\u672a\u4e00\u81f4\u3060\u3063\u305f\u30e6\u30fc\u30b6\u30fc\u306e`o.status`\u306fNULL\u3067\u3059\u3002`WHERE o.status = &#39;ACTIVE&#39;`\u306f\u305d\u306e\u884c\u3092true\u306b\u3067\u304d\u306a\u3044\u305f\u3081\u3001WHERE\u6bb5\u968e\u3067\u53d6\u308a\u9664\u304b\u308c\u307e\u3059\u3002\u7d50\u679c\u3060\u3051\u3092\u898b\u308b\u3068INNER JOIN\u306b\u8fd1\u3044\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<hr>\n<h2>\u5de6\u5074\u306e\u884c\u3092\u6b8b\u3057\u305f\u3044\u306a\u3089\u53f3\u8868\u6761\u4ef6\u3092ON\u3078\u79fb\u3059<\/h2>\n<p>\u76ee\u7684\u304c\u300c\u5168\u30e6\u30fc\u30b6\u30fc\u3092\u6b8b\u3057\u3064\u3064\u3001ACTIVE\u306a\u6ce8\u6587\u3060\u3051\u3092\u7d50\u5408\u3059\u308b\u300d\u306a\u3089\u3001\u53f3\u30c6\u30fc\u30d6\u30eb\u3078\u304b\u3051\u308b\u6761\u4ef6\u3092JOIN\u6761\u4ef6\u3078\u542b\u3081\u307e\u3059\u3002<\/p>\n<pre><code>SELECT\r\n    u.id,\r\n    u.name,\r\n    o.id AS order_id\r\nFROM users u\r\nLEFT JOIN orders o\r\n    ON o.user_id = u.id\r\n   AND o.status = &#39;ACTIVE&#39;;<\/code><\/pre>\n<p>\u3053\u306e\u5834\u5408\u3001ACTIVE\u306a\u6ce8\u6587\u304c\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3082\u5de6\u5074\u884c\u3068\u3057\u3066\u6b8b\u308a\u3001`order_id`\u306a\u3069\u53f3\u5074\u5217\u304cNULL\u306b\u306a\u308a\u307e\u3059\u3002\u6761\u4ef6\u3092ON\u3078\u79fb\u3059\u306e\u306f\u898b\u305f\u76ee\u306e\u6574\u7406\u3067\u306f\u306a\u304f\u3001\u5916\u90e8\u7d50\u5408\u3067\u3069\u306e\u884c\u3092\u300c\u4e00\u81f4\u300d\u3068\u307f\u306a\u3059\u304b\u3092\u5909\u3048\u308b\u64cd\u4f5c\u3067\u3059\u3002<\/p>\n<hr>\n<h2>\u306a\u305cON\u3068WHERE\u3067\u7d50\u679c\u304c\u5909\u308f\u308b\u306e\u304b<\/h2>\n<p>LEFT JOIN\u306f\u3001\u307e\u305aON\u6761\u4ef6\u3067\u5de6\u53f3\u306e\u884c\u3092\u7167\u5408\u3057\u307e\u3059\u3002\u4e00\u81f4\u3059\u308b\u53f3\u884c\u304c\u306a\u3051\u308c\u3070\u3001\u5de6\u884c\u306b\u53f3\u5074NULL\u3092\u4ed8\u3051\u3066\u7d50\u679c\u3078\u6b8b\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c\u3001WHERE\u306fJOIN\u5f8c\u306e\u884c\u3092\u7d5e\u308a\u8fbc\u307f\u307e\u3059\u3002<\/p>\n<ul>\n<li>ON\uff1a\u53f3\u5074\u306e\u3069\u306e\u884c\u3092\u7d50\u5408\u76f8\u624b\u3068\u3057\u3066\u8a8d\u3081\u308b\u304b\u3092\u6c7a\u3081\u308b<\/li>\n<li>LEFT JOIN\uff1a\u4e00\u81f4\u3057\u306a\u3044\u5de6\u884c\u3092\u53f3\u5074NULL\u3067\u88dc\u3046<\/li>\n<li>WHERE\uff1aJOIN\u5f8c\u306b\u3067\u304d\u305f\u5404\u884c\u3092\u6b8b\u3059\u304b\u843d\u3068\u3059\u304b\u3092\u6c7a\u3081\u308b<\/li>\n<\/ul>\n<p>\u305d\u306e\u305f\u3081\u5916\u90e8\u7d50\u5408\u3067\u306f\u3001ON\u6761\u4ef6\u3068WHERE\u6761\u4ef6\u306f\u5e38\u306b\u7f6e\u304d\u63db\u3048\u53ef\u80fd\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002PostgreSQL\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3082\u3001outer join\u306eON\/USING\u6761\u4ef6\u306fWHERE\u6761\u4ef6\u3068\u7b49\u4fa1\u3067\u306f\u306a\u3044\u3068\u660e\u8a18\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<blockquote>\n<p><strong>\u7528\u8a9e\u89e3\u8aac\uff1aNULL\u88dc\u5b8c\u884c<\/strong><br \/>LEFT JOIN\u3067\u53f3\u5074\u306b\u4e00\u81f4\u3059\u308b\u884c\u304c\u306a\u3044\u3068\u304d\u3001\u5de6\u5074\u306e\u884c\u3092\u6b8b\u3059\u305f\u3081\u306b\u53f3\u5074\u5217\u3078NULL\u3092\u5165\u308c\u3066\u4f5c\u3089\u308c\u308b\u7d50\u679c\u884c\u3067\u3059\u3002<\/p>\n<\/blockquote>\n<h2>\u3059\u3079\u3066\u306eWHERE\u6761\u4ef6\u3092ON\u3078\u79fb\u305b\u3070\u3088\u3044\u308f\u3051\u3067\u306f\u306a\u3044<\/h2>\n<p>\u6761\u4ef6\u306e\u7f6e\u304d\u5834\u6240\u306f\u300c\u4f55\u3092\u6b8b\u3057\u305f\u3044\u304b\u300d\u3067\u6c7a\u3081\u307e\u3059\u3002\u5de6\u30c6\u30fc\u30d6\u30eb\u81ea\u4f53\u3092\u7d5e\u308a\u305f\u3044\u6761\u4ef6\u307e\u3067ON\u3078\u79fb\u3059\u3068\u3001\u610f\u56f3\u3068\u9055\u3046\u7d50\u679c\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th>\u76ee\u7684<\/th>\n<th>\u7f6e\u304d\u5834\u6240\u306e\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u6771\u4eac\u306e\u30e6\u30fc\u30b6\u30fc\u3060\u3051\u3092\u5bfe\u8c61\u306b\u3059\u308b<\/td>\n<td>WHERE u.prefecture = &#39;Tokyo&#39;<\/td>\n<\/tr>\n<tr>\n<td>ACTIVE\u306a\u6ce8\u6587\u3060\u3051\u3092\u7d50\u5408\u3059\u308b<\/td>\n<td>ON &#8230; AND o.status = &#39;ACTIVE&#39;<\/td>\n<\/tr>\n<tr>\n<td>ACTIVE\u306a\u6ce8\u6587\u3092\u6301\u3064\u30e6\u30fc\u30b6\u30fc\u3060\u3051\u53d6\u5f97\u3059\u308b<\/td>\n<td>INNER JOIN\u307e\u305f\u306fLEFT JOIN + WHERE\u3092\u610f\u56f3\u7684\u306b\u4f7f\u3046<\/td>\n<\/tr>\n<tr>\n<td>\u6ce8\u6587\u3092\u4e00\u4ef6\u3082\u6301\u305f\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3092\u63a2\u3059<\/td>\n<td>LEFT JOIN\u5f8c\u306bWHERE o.id IS NULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u7279\u306b\u300c\u53f3\u5074\u6761\u4ef6\u304c\u3042\u308bWHERE\u306f\u5168\u90e8\u60aa\u3044\u300d\u3068\u899a\u3048\u308b\u306e\u306f\u5371\u967a\u3067\u3059\u3002\u672a\u4e00\u81f4\u884c\u3092\u6b8b\u3057\u305f\u3044\u306e\u304b\u3001\u305d\u308c\u3068\u3082\u53f3\u5074\u6761\u4ef6\u3092\u6e80\u305f\u3059\u884c\u3060\u3051\u6b32\u3057\u3044\u306e\u304b\u3092\u5148\u306b\u6c7a\u3081\u307e\u3059\u3002<\/p>\n<h2>\u6ce8\u6587\u304c\u306a\u3044\u884c\u3092\u63a2\u3059\u306a\u3089IS NULL\u3092\u4f7f\u3046<\/h2>\n<p>LEFT JOIN\u306eNULL\u88dc\u5b8c\u3092\u610f\u56f3\u7684\u306b\u5229\u7528\u3059\u308b\u3068\u3001\u300c\u5bfe\u5fdc\u3059\u308b\u53f3\u5074\u884c\u304c\u5b58\u5728\u3057\u306a\u3044\u5de6\u5074\u884c\u300d\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre><code>SELECT\r\n    u.id,\r\n    u.name\r\nFROM users u\r\nLEFT JOIN orders o\r\n    ON o.user_id = u.id\r\nWHERE o.id IS NULL;<\/code><\/pre>\n<p>\u3053\u306e\u30d1\u30bf\u30fc\u30f3\u306f\u300c\u6ce8\u6587\u304c\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u300d\u306e\u3088\u3046\u306a\u672a\u4e00\u81f4\u30c7\u30fc\u30bf\u3092\u63a2\u3059\u3068\u304d\u306b\u4f7f\u3048\u307e\u3059\u3002\u3053\u3053\u3067\u306fWHERE\u3067NULL\u884c\u3092\u6b8b\u3059\u3053\u3068\u81ea\u4f53\u304c\u76ee\u7684\u306a\u306e\u3067\u3001WHERE\u306e\u4f7f\u7528\u306f\u610f\u56f3\u3069\u304a\u308a\u3067\u3059\u3002<\/p>\n<h2>\u5207\u308a\u5206\u3051\u306f\u53f3\u5074\u5217\u3092WHERE\u3067\u53c2\u7167\u3057\u3066\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3059\u308b<\/h2>\n<ul>\n<li>LEFT JOIN\u306e\u53f3\u5074\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u3092WHERE\u3067\u7d5e\u3063\u3066\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3059\u308b<\/li>\n<li>\u305d\u306e\u6761\u4ef6\u304c\u300c\u7d50\u5408\u76f8\u624b\u306e\u6761\u4ef6\u300d\u306a\u306e\u304b\u300c\u6700\u7d42\u7d50\u679c\u306e\u7d5e\u308a\u8fbc\u307f\u300d\u306a\u306e\u304b\u8a00\u8a9e\u5316\u3059\u308b<\/li>\n<li>\u5de6\u5074\u306e\u672a\u4e00\u81f4\u884c\u3092\u6b8b\u3057\u305f\u3044\u306a\u3089\u53f3\u5074\u6761\u4ef6\u3092ON\u3078\u79fb\u3059<\/li>\n<li>\u4e00\u81f4\u884c\u3060\u3051\u5fc5\u8981\u306a\u3089INNER JOIN\u306e\u65b9\u304c\u610f\u56f3\u3092\u4f1d\u3048\u3084\u3059\u3044\u304b\u691c\u8a0e\u3059\u308b<\/li>\n<li>\u672a\u4e00\u81f4\u884c\u3092\u63a2\u3059\u76ee\u7684\u306a\u3089WHERE right.id IS NULL\u3092\u691c\u8a0e\u3059\u308b<\/li>\n<\/ul>\n<p>\uff08INNER\u30fbLEFT\u30fbRIGHT\u306a\u3069JOIN\u81ea\u4f53\u306e\u57fa\u672c\u3092\u5148\u306b\u6574\u7406\u3057\u305f\u3044\u5834\u5408\u306b\u3064\u3044\u3066\u306f\u300e<a href=\"https:\/\/route-zero.com\/recruit\/route\/1119\/\">SQL JOIN\u306e\u57fa\u672c\u304b\u3089\u5b9f\u8df5\u307e\u3067\uff5cINNER\u30fbLEFT\u30fbRIGHT\u30fbOUTER JOIN\u306e\u9055\u3044\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac<\/a>\u300f\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\uff09<\/p>\n<p>\u30c7\u30d0\u30c3\u30b0\u6642\u306f\u3001\u3044\u3063\u305f\u3093WHERE\u3092\u5916\u3057\u3066\u53f3\u5074\u5217\u304cNULL\u306b\u306a\u3063\u3066\u3044\u308b\u884c\u3092\u78ba\u8a8d\u3059\u308b\u3068\u3001JOIN\u306e\u6bb5\u968e\u3067\u6d88\u3048\u3066\u3044\u308b\u306e\u304b\u3001WHERE\u306e\u6bb5\u968e\u3067\u6d88\u3048\u3066\u3044\u308b\u306e\u304b\u3092\u5207\u308a\u5206\u3051\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<h2>\u3088\u304f\u3042\u308b\u8cea\u554f<\/h2>\n<h3>LEFT JOIN\u306bWHERE\u3092\u66f8\u3044\u305f\u3089\u5fc5\u305aINNER JOIN\u3068\u540c\u3058\u306b\u306a\u308a\u307e\u3059\u304b\uff1f<\/h3>\n<p>\u5fc5\u305a\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u53f3\u5074\u5217\u3078NULL\u3092\u8a31\u3055\u306a\u3044\u6761\u4ef6\u3092WHERE\u306b\u7f6e\u304f\u3068\u672a\u4e00\u81f4\u884c\u304c\u843d\u3061\u3001INNER JOIN\u306b\u8fd1\u3044\u7d50\u679c\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002WHERE\u306e\u6761\u4ef6\u5185\u5bb9\u306b\u3088\u3063\u3066\u7d50\u679c\u306f\u5909\u308f\u308a\u307e\u3059\u3002<\/p>\n<h3>\u53f3\u30c6\u30fc\u30d6\u30eb\u306e\u6761\u4ef6\u306f\u5168\u90e8ON\u306b\u66f8\u304f\u3079\u304d\u3067\u3059\u304b\uff1f<\/h3>\n<p>\u3044\u3044\u3048\u3002\u5de6\u5074\u306e\u672a\u4e00\u81f4\u884c\u3092\u6b8b\u3057\u305f\u307e\u307e\u7d50\u5408\u76f8\u624b\u3092\u5236\u9650\u3057\u305f\u3044\u6761\u4ef6\u306fON\u304c\u9069\u3057\u307e\u3059\u304c\u3001JOIN\u5f8c\u306e\u6700\u7d42\u7d50\u679c\u3092\u7d5e\u308b\u6761\u4ef6\u306fWHERE\u304c\u9069\u3057\u307e\u3059\u3002\u76ee\u7684\u3067\u5206\u3051\u307e\u3059\u3002<\/p>\n<h3>\u6ce8\u6587\u304c\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3060\u3051\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u3069\u3046\u3057\u307e\u3059\u304b\uff1f<\/h3>\n<p>LEFT JOIN\u3057\u305f\u5f8c\u3001\u53f3\u5074\u306e\u8b58\u5225\u5b50\u306a\u3069\u78ba\u5b9f\u306b\u975eNULL\u3067\u3042\u308b\u5217\u306b\u5bfe\u3057\u3066`WHERE o.id IS NULL`\u3068\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>LEFT JOIN\u3067\u60f3\u5b9a\u3088\u308a\u884c\u6570\u304c\u6e1b\u3063\u305f\u3089\u3001\u307e\u305aWHERE\u53e5\u306e\u4e2d\u306b\u53f3\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u304c\u306a\u3044\u304b\u78ba\u8a8d\u3057\u3001\u305d\u306e\u6761\u4ef6\u3092ON\u3078\u7f6e\u3044\u305f\u5834\u5408\u3068\u306e\u7d50\u679c\u3092\u6bd4\u8f03\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"featured_media":6414,"template":"","meta":{"ssp_meta_title":"LEFT JOIN\u3067\u884c\u304c\u6d88\u3048\u308b\u539f\u56e0\uff5cWHERE\u3068ON\u306e\u9055\u3044","ssp_meta_description":"LEFT JOIN\u306a\u306e\u306b\u5de6\u8868\u306e\u884c\u304c\u6d88\u3048\u308b\u539f\u56e0\u3092\u3001WHERE\u6761\u4ef6\u3068ON\u6761\u4ef6\u306e\u9055\u3044\u304b\u3089\u89e3\u8aac\u3002\u53f3\u8868\u6761\u4ef6\u3067NULL\u884c\u304c\u9664\u5916\u3055\u308c\u308b\u4ed5\u7d44\u307f\u3001\u6b63\u3057\u3044\u66f8\u304d\u63db\u3048\u3001\u4f8b\u5916\u30b1\u30fc\u30b9\u3092SQL\u4f8b\u3067\u6574\u7406\u3057\u307e\u3059\u3002","ssp_meta_keyword":"LEFT JOIN WHERE \u6761\u4ef6,LEFT JOIN \u884c \u6d88\u3048\u308b,LEFT JOIN INNER JOIN,SQL ON WHERE \u9055\u3044,outer join null,SQL JOIN \u6761\u4ef6","ssp_meta_canonical":""},"route_category":[9],"_links":{"self":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route\/6413"}],"collection":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route"}],"about":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/types\/route"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/media\/6414"}],"wp:attachment":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/media?parent=6413"}],"wp:term":[{"taxonomy":"route_category","embeddable":true,"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route_category?post=6413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}