{"categories":["study"],"published":"2008-08-11 00:00:06","height":"190","version":"1.0","width":"100%","blog_url":"https://kiririmode.hatenablog.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkiririmode.hatenablog.jp%2Fentry%2F20080811%2Fp7\" title=\"\u554f\u984c3-4 (Query Primer) - \u7406\u7cfb\u5b66\u751f\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"|mysql| mysql> SELECT p.product_cd, a.cust_id, a.avail_balance -> FROM product p INNER JOIN account a -> ON p.product_cd = a.product_cd -> WHERE p.product_type_cd = 'ACCOUNT'; +------------+---------+---------------+ | product_cd | cust_id | avail_balance | +------------+---------+---------------+ |\u2026","blog_title":"\u7406\u7cfb\u5b66\u751f\u65e5\u8a18","author_url":"https://blog.hatena.ne.jp/kiririmode/","type":"rich","provider_url":"https://hatena.blog","author_name":"kiririmode","image_url":null,"provider_name":"Hatena Blog","url":"https://kiririmode.hatenablog.jp/entry/20080811/p7","title":"\u554f\u984c3-4 (Query Primer)"}