OK just to clarify Table A holds unique ID's as below, Table B holds a number value example 2. So I need to insert 2 rows per unique ID...

Thanks for the replies all..

But I'm not quite getting round to what I require.. basically I have a Table A, Table B as example below and Table C should read...

OK, what I;m trying to work out is if Table A holds a column with a number, I need to pick that number e.g. 2 and enter 2 rows in...