Click here to Skip to main content
Sign Up to vote bad
good
See more: TSQL
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:54

Comments
gvprabu - 28 Sep '12 - 5:19
If u want to make thru joins... Its difficult.

2 solutions

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
  Permalink  
Comments
Manas Bhardwaj - 28 Sep '12 - 5:16
5+
Mohamed Mitwalli - 3 Oct '12 - 1:44
Thanks Manas :)
gvprabu - 28 Sep '12 - 5:16
Hi Mohamed Mitwalli, ur query will give different Output., pls check with sample...
Mohamed Mitwalli - 3 Oct '12 - 1:45
Thanks and i will check it :)
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....
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 255
1 Mahesh Bailwal 230
2 Aarti Meswania 225
3 Ron Beyer 215
4 Rohan Leuva 198
0 Sergey Alexandrovich Kryukov 8,553
1 OriginalGriff 6,899
2 CPallini 3,648
3 Rohan Leuva 2,963
4 Maciej Los 2,308


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 28 Sep 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid