How to Join in TSQL

Question

0.00/5 (No votes)

See more:

I have two table A and B,

Table A.

HTML

col 1    col 2
Row1     A
Row2     A
Row3     A
Row4     A
Row5     A
Row6     A

Table B.

HTML

col 1    col 2
Row1     B
Row2     B
Row3     B

and I need following output

HTML

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

Kailash_Singh

Add a Solution

Comments

gvprabu 28-Sep-12 5:19am

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

2 solutions

Solution 2

Hi Check the Following Example ....

SQL

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....

Posted 27-Sep-12 23:10pm

gvprabu

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mohamed Mitwalli · Accepted Answer · 2012-09-11T19:59:00

Solution 1

Hi ,
Check this

SQL

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

Posted 11-Sep-12 19:59pm

Mohamed Mitwalli

Comments

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 :)