{"product_id":"sql-left-join-developer-tshirt","title":"LEFT JOIN Developer T-Shirt","description":"\u003cp\u003e`LEFT JOIN` returns every row from the left table, matched with the right where a match exists and filled with `NULL` where it doesn't.\u003c\/p\u003e\n\u003cp\u003eThe distinction from `INNER JOIN` is the whole point: it keeps the rows that didn't match instead of silently dropping them. Reach for it when absence is data too.\u003cbr\u003e\u003c\/p\u003e","brand":"Slash Star","offers":[{"title":"Black Heather \/ XS","offer_id":58337590804861,"sku":"4785582_9575","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"Black Heather \/ S","offer_id":58337590837629,"sku":"4785582_8923","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"Black Heather \/ M","offer_id":58337590870397,"sku":"4785582_8924","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"Black Heather \/ L","offer_id":58337590903165,"sku":"4785582_8925","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"Black Heather \/ XL","offer_id":58337590935933,"sku":"4785582_8926","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"Black Heather \/ 2XL","offer_id":58337590968701,"sku":"4785582_8927","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ XS","offer_id":58337591001469,"sku":"4785582_9526","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ S","offer_id":58337591034237,"sku":"4785582_4011","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ M","offer_id":58337591067005,"sku":"4785582_4012","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ L","offer_id":58337591099773,"sku":"4785582_4013","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ XL","offer_id":58337591132541,"sku":"4785582_4014","price":25.0,"currency_code":"GBP","in_stock":true},{"title":"White \/ 2XL","offer_id":58337591165309,"sku":"4785582_4015","price":25.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0925\/2860\/7613\/files\/unisex-staple-t-shirt-black-heather-front-6a45101e77499.jpg?v=1782911016","url":"https:\/\/slashstar.store\/products\/sql-left-join-developer-tshirt","provider":"Slash Star","version":"1.0","type":"link"}