MS SQL

MS SQL RSS

Joining two tables

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Nov 2008

Posts: 2

Reputation: rebeka.six is an unknown quantity at this point

Solved Threads: 0

rebeka.six rebeka.six is offline

Offline

Newbie Poster

Joining two tables

Nov 22nd, 2008

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

•

Join Date: Aug 2008

Posts: 1,160

Reputation: dickersonka will become famous soon enough

Solved Threads: 137

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: Joining two tables

Nov 23rd, 2008

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?

Custom Application & Software Development
www.houseshark.net

•

Join Date: Feb 2008

Posts: 40

Reputation: huangzhi is an unknown quantity at this point

Solved Threads: 13

huangzhi

Offline

Light Poster

Re: Joining two tables

Nov 24th, 2008

Try this command:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT	T1.idx, T2.idy, T2.u
  FROM	Table1 T1 RIGHT JOIN Table2 T2 ON
	T1.idy = T2.Idy AND T1.idx = 'one'
select	T1.idx, T2.idy, T2.u
  from	Table1 T1 right join Table2 T2 on
	T1.idy = T2.Idy and T1.idx = 'one'