|
-
Aug 18th, 2009, 02:54 PM
#1
Thread Starter
Addicted Member
[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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|