Hello! Trying to understand INNER JOINs better:
What is the maximum number of rows that can be returned when you join 2 tables?
Also - let’s say we are joining on a column called ID between two hypothetical tables A and B : table A has 5 rows for ID 1, table B has 10 rows for ID 1, after the INNER JOIN, how many rows would be returned for ID 1 ?
Thank you in advance