Inner join would never give more results than a left or right outer join. What I think is required here is a cross join. That will take all records from the left table (3) and combine them all with all records from the right table (9). The result would be the intended 3 * 9 = 27 records.