If you perform an inner join, many rows will become?

An inner join returns only the rows that have matching values in both tables. When you perform an inner join, any row that does not find a match in the other table is discarded. This means the result set will contain only the rows that satisfy the join condition, and the total number of rows will usually be less than or equal to the number of rows in the smaller table. For example, if Table A has 5 rows and Table B has 3 rows, and only 2 rows match on the join key, the inner join will return just those 2 rows. The key point is that inner joins filter out non‑matching rows, so the output can be smaller than the input tables.