12,064,615 members (25,118 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 20: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
 d@nish 200 CPallini 130 CHill60 120 OriginalGriff 90 RDBurmon 50
 Dave Kreskowiak 1,857 Richard MacCutchan 1,250 d@nish 980 OriginalGriff 874 Sergey Alexandrovich Kryukov 762