Jul 22, 2017 · 1 min read
Thanks for the post. I believe it would have been better if you included some sample data, in two tables, with the output from the queries. For example, two tables with data, referencing the table columns in the queries and highlighting what’s returned versus what’s not returned so we can see the differences more clearly. I’ve always found the topic of joins hard to grasp hence my eagerness to read this post. I always use implicit joins with queries like:
SELECT columns
FROM tableA, tableB
WHERE tableA.foreign_key_column = tableB.primary_key_column
AND condition;
I think that qualifies as an inner join. I found it a bit hard to follow along. I am still not clear on the differences.
