12,547,501 members (40,675 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+
Mohamed Mitwalli 3-Oct-12 1:44am

Thanks Manas :)
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: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
 Suvendu Shekhar Giri 255 OriginalGriff 210 Maciej Los 130 Karthik Bangalore 90 Rbabs 80
 OriginalGriff 3,827 John Simmons / outlaw programmer 1,687 Suvendu Shekhar Giri 1,633 ppolymorphe 1,441 Karthik Bangalore 1,170