13,143,708 members (27,987 online)
Rate this:
See more:
I have two table A and B,

Table A.
```col 1    col 2
Row1     A
Row2     A
Row3     A
Row4     A
Row5     A
Row6     A```

Table B.
```col 1    col 2
Row1     B
Row2     B
Row3     B```

and I need following output

```Row1     A
Row1     B
Row2     A
Row2     B
Row3     A
Row3     B```

how can I do this, thanx in advanced...
Posted 11-Sep-12 19:54pm
gvprabu 28-Sep-12 5:19am

If u want to make thru joins... Its difficult.

Rate this:

## Solution 1

Hi ,
Check this
```select tb1.Col1 , tb2.col2 from tableA  as tb1 Inner join
Tableb as tb2 on tb1.col1 = tb2.col1```

SQL Joins[^]
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]
Best Regards
M.Mitwalli
Manas Bhardwaj 28-Sep-12 5:16am

5+
gvprabu 28-Sep-12 5:16am

Hi Mohamed Mitwalli,
ur query will give different Output., pls check with sample...
Mohamed Mitwalli 3-Oct-12 1:44am

Thanks Manas :)
Mohamed Mitwalli 3-Oct-12 1:45am

Thanks and i will check it :)
Rate this:

## Solution 2

Hi Check the Following Example ....

```CREATE TABLE dbo.Tab1 (Col1 VARCHAR(10), Col2 VARCHAR(10))
CREATE TABLE dbo.Tab2 (Col1 VARCHAR(10), Col2 VARCHAR(10))

INSERT INTO dbo.Tab1 (Col1, Col2)
SELECT 'Row1','A'
UNION ALL
SELECT 'Row2','A'
UNION ALL
SELECT 'Row3','A'
UNION ALL
SELECT 'Row4','A'
UNION ALL
SELECT 'Row5','A'
UNION ALL
SELECT 'Row6','A'

INSERT INTO  dbo.Tab2 (Col1, Col2)
SELECT 'Row1','B'
UNION ALL
SELECT 'Row2','B'
UNION ALL
SELECT 'Row3','B'

SELECT T2.Col1,T2.Col2
FROM dbo.Tab2 T2
UNION
SELECT T1.Col1 , T1.Col2
FROM dbo.Tab1 T1
WHERE T1.Col1 IN (SELECT Col1 FROM dbo.Tab2)
```

It will helps u....

Top Experts
Last 24hrsThis month
 OriginalGriff 358 Dave Kreskowiak 170 Richard MacCutchan 110 Richard Deeming 95 Jochen Arndt 95
 OriginalGriff 5,450 Graeme_Grant 5,053 ppolymorphe 1,834 Jochen Arndt 1,804 CPallini 1,560