Sql combining two tables.

[kingstonr]

HI,

I Have two tables table1 and table2

Table1
--------
id Name
1 Test1

Table 2
--------
id Name
1 Test2

I need the result like below

Table1id Table2id Table1name Table2name
1 2 Test1 Test2

Can anybody help me in this.

Thanks
Kingston

 

[gmmastros]

Select Table1.Id,
       Table1.Name As Table1Name,
       Table2.Name As Tablee2Name
From   Table1
       Inner Join Table2
         On Table1.Id = Table2.Id

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

What if you have these values:
[tt]
Table1
--------
id Name
-------------
1 Test1_1
2 Test1_2


Table 2
--------
id Name
---------
1 Test2_1
2 Test2_2
3 Test2_3
4 Test2_3
[/tt]
What result you want?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[kingstonr]

Thanks George.

Borissov in my case Name is unique.

 

[bborissov]

OK, in mine too.
[tt]
Table1
--------
id Name
-------------
1 Test1_1
2 Test1_2


Table 2
--------
id Name
---------
1 Test2_1
2 Test2_2
3 Test2_3
4 Test2_4
[/tt]
There is no duplicated Name in both tables. But I have more records in one table than another. So my question is still here. What you want if you have such data?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP