12,943,742 members (58,624 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
 Maciej Los 220 CHill60 145 ppolymorphe 140 OriginalGriff 98 RyanDev 85
 OriginalGriff 4,643 CHill60 2,970 Maciej Los 2,348 Jochen Arndt 1,900 ppolymorphe 1,765