Hi,
I can’t work this 
using MySQL 5.1.45-community.
I have two tables and need a new table populated so there it loops through table one and two to make multiple rows for ever row.
t1
id | a1
1 | a
2 | b
t2
id | b1
1 | 4
2 | 3
3 | 7
desired result new table
id | a1 | b1
1 | a | 4
2 | a | 3
3 | a | 7
4 | b | 4
5 | b | 3
6 | b | 7
Hopefully i have explained it, i cant work it out.
