Inner join giving unwanted rows

[christhedonstar]

Hi,
Say I have a table favourite numbers ( the '|' represents column barrier)
Chris | 1
Chris | 7
Abu | 4
and I have a names table where it has address in as well

Chris | Flat 4
Abu | Flat 6
and I do an inner join on the two tables on name
then I'll end up with 3 rows

Chris | Flat 4 | 1
Chris | Flat 4 | 7
Abu | Flat 6 | 4

but say I wanted just two rows, I.e.,

Chris | Flat 4 | 1 | 7
Abu | Flat 6 | 4 |

Is there an easy way to do this?

Thanks,

Chris