# Tweets From Dr. Milan Milanović ![rw-book-cover](https://pbs.twimg.com/profile_images/1079879617681543169/3i2gaxfX.jpg) ## Metadata - Author: [[@milan_milanovic on Twitter]] - Full Title: Tweets From Dr. Milan Milanović - Category: #tweets - URL: https://twitter.com/milan_milanovic ## Highlights - 𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗜𝗻𝗻𝗲𝗿, 𝗟𝗲𝗳𝘁, 𝗥𝗶𝗴𝗵𝘁, 𝗮𝗻𝗱 𝗙𝘂𝗹𝗹 𝗷𝗼𝗶𝗻? 🔹 (𝗜𝗡𝗡𝗘𝗥) 𝗝𝗢𝗜𝗡: return all rows with matching values in both tables. 🔹 𝗟𝗘𝗙𝗧 (𝗢𝗨𝗧𝗘𝗥) 𝗝𝗢𝗜𝗡: return all rows from the left table and those that meet the condition from the right table. 🔹 𝗥𝗜𝗚𝗛𝗧 (𝗢𝗨𝗧𝗘𝗥) 𝗝𝗢𝗜𝗡: return all rows from the right table and those that meet the condition from the left table. 🔹 𝗙𝗨𝗟𝗟 (𝗢𝗨𝗧𝗘𝗥) 𝗝𝗢𝗜𝗡: return all rows which either have a match in either table. The diagram below illustrates how different types of joins work in the form of checkered flag diagrams. (Credits: Hadley Wickham & Garrett Grolemund in their book "R for Data Science," prepared as a cheatsheet by Andreas Martinson). #sql<img src='https://pbs.twimg.com/media/GBjUc_5XgAAajAA.jpg'/> ([View Tweet](https://twitter.com/milan_milanovic/status/1736371310614270131))