[RESOLVED] SQL "JOIN" (I think)

I have two tables (simplified below)

Table A
x desc
-----
1 xxx
2 xxx
3 xxx

Table B
desc
-----
abc
def
ghi

I need to insert in to a third table, from these two tables
replacing xxx with abc, def, ghi

so that I have 9 columns inserted in to my third day

ie
Table B
x desc
------
1 abc
2 abc
3 abc
1 def
2 def
3 def
1 ghi
2 ghi
3 ghi

as there are no matching columns in these two tables, I don't know how to join them?
I tried using <> but that didn't seen to work

any help would be appreciated here
Thanks

Use a cross join

sql Code:

Insert into TableC 
select TableA.X, TableB.Desc 
from TableA, TableB

cheers Pradeep,

If I wanted to multiply x by a value from table b as well, that would work too yeah?

Put whatever you need in the select statement.
e.g.

sql Code:

Insert into TableC 
select TableA.X * 10, TableB.Desc 
from TableA, TableB

Top man!

Still just learning SQL, was confusing myself with all kinds of joins etc

Thanks again!!

If you just want to see the results without inserting into a third table, just remove that INSERT part

sql Code:

select TableA.X * 10, TableB.Desc 
from TableA, TableB