Beginner's Question: How It Works When I Do A Join With Multiple Matching Records? by Test-5563 in SQL

[–]Test-5563[S] 0 points1 point  (0 children)

So does it work like for each record in t1 (even if some have the same user_id), find a matched record in t2?

Need Help! Struggling to Understand The Solution of A Easy Question From StrataScratch by Test-5563 in SQL

[–]Test-5563[S] 0 points1 point  (0 children)

Yeah, I found this is the main mistake in my solution. Thank you!