Joining two tables
Please support our MS SQL advertiser: Programming Forums
Thread Solved
 |
I need help with joining these two tables:
Table1
idx idy
---------
one 1
two 2
tree 3
Table2
idy u
-------
1 a
2 b
3 c
4 d
5 e
6 f
I want to show rows from the Table1 that have idx=one joined with all the rows from Table2.
So, I want to join these two tables so that Table1.idy=Table2.idy and Table1.idx=one
The result table should look like this.
Result table:
idx idy u
--------------
one 1 a
NULL 2 b
NULL 3 c
NULL 4 d
NULL 5 e
NULL 6 f
Could someone help me with this?
Thanks.
Rebeka
Table1
idx idy
---------
one 1
two 2
tree 3
Table2
idy u
-------
1 a
2 b
3 c
4 d
5 e
6 f
I want to show rows from the Table1 that have idx=one joined with all the rows from Table2.
So, I want to join these two tables so that Table1.idy=Table2.idy and Table1.idx=one
The result table should look like this.
Result table:
idx idy u
--------------
one 1 a
NULL 2 b
NULL 3 c
NULL 4 d
NULL 5 e
NULL 6 f
Could someone help me with this?
Thanks.
Rebeka
i don't see how you are expecting idx = NULL for 2-6, when you have both entries for idy in both tables
are you sure this is what you are wanting?
are you sure this is what you are wanting?
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
Try this command:
select T1.idx, T2.idy, T2.u from Table1 T1 right join Table2 T2 on T1.idy = T2.Idy and T1.idx = 'one'
Hence Wijaya
www.ex-Soft.tk
www.ex-Soft.tk
|
Similar Threads
Other Threads in the MS SQL Forum
- Joining two tables in VB 6 (Visual Basic 4 / 5 / 6)
- Join multiple tables (VB.NET)
- Joining 4 or more tables (MySQL)
- ..joining 2 tables?=A tuf one....can U crack this ? (VB.NET)
- Need Help Joining 3 tables (MySQL)
Other Threads in the MS SQL Forum
- Previous Thread: Transfer of data
- Next Thread: Need Advice please
•
•
•
•
Views: 748 | Replies: 3 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
