Sébastien Reuiller retweetledi

𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗜𝗻𝗻𝗲𝗿, 𝗟𝗲𝗳𝘁, 𝗥𝗶𝗴𝗵𝘁, 𝗮𝗻𝗱 𝗙𝘂𝗹𝗹 𝗝𝗼𝗶𝗻?
🔹 (INNER) JOIN - return all rows with matching values in both tables.
🔹 LEFT (OUTER) JOIN - return all rows from the left table and those that meet the condition from the right table.
🔹 RIGHT (OUTER) JOIN - return all rows from the right table and those that meet the condition from the left table.
🔹 FULL (OUTER) JOIN - return all rows with a match in either table.
Image credits: Andreas Martinson.
#technology #softwareengineering #data #techworldwithmilan #sql

English



























