The latest articles on DEV Community by 𝓐𝓵𝓠𝓪𝓺𝓪𝓪 𝓑𝓮𝓷𝓰𝓱𝓾𝔃𝓲 ☪ (@alqaqaaben). https://dev.to/alqaqaaben https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F218233%2Fd5f672bc-6c66-430f-9ba8-136addea7eea.jpg https://dev.to/alqaqaaben en 𝓐𝓵𝓠𝓪𝓺𝓪𝓪 𝓑𝓮𝓷𝓰𝓱𝓾𝔃𝓲 ☪ Wed, 24 Jun 2020 18:54:29 +0000 https://dev.to/alqaqaaben/what-s-the-difference-between-the-sub-select-and-left-jion-sql-query-1cm2 https://dev.to/alqaqaaben/what-s-the-difference-between-the-sub-select-and-left-jion-sql-query-1cm2 <p>In the following example, every query clause has the same result, so what is the difference between the two clauses of the query in terms of speed in returning data from database? </p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--B5hzTsDa--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/emfi26s1menwwz440wsy.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--B5hzTsDa--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/emfi26s1menwwz440wsy.png" alt="Alt Text"></a></p> sql