[RESOLVED] SQL "JOIN" (I think)

[Mitch_s_s]

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

[Pradeep1210]

Use a cross join

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

[Mitch_s_s]

cheers Pradeep,

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

[Pradeep1210]

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

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

[Mitch_s_s]

Top man!

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

Thanks again!!

[Pradeep1210]

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

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