I am having problems joining two tables?

[mimic]

Hi all,I am having problems joining two tables together.
Table1
ID Name
1 A
2 B
3 C
Table2
ID name
1 D
2 E
3 F
I would like to make the query same
ID name
1 A
1 D
2 B
2 E
3 C
3 F
Can anyone help please? It would be much appreciated.
Many Thanks, mimic

 

[ansentry]

Why not put them all in 1 table?

What is it about the data that is should be in separate tables?

 

[RuralGuy]

I agree with John but if you really must keep them in separate tables then a UNION query can put them together form you.