|
-
Dec 5th, 2008, 08:59 AM
#1
Thread Starter
Frenzied Member
[RESOLVED] Insert into from 2 tables
Hey,
I got 2 tables each with their own key
Table 1
Key1
Table2
Key2
I need a SQL statement that will insert into Table3 Key1 as primary and Key2 as foreign.
What would be the best way to do that?
Table3 end result would look like:
Key1 | Key2
1 | 1
2 | 1
3 | 1
1 | 2
2 | 2
3 | 2
Thanks for any direction.
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
|