How to use join in sql

Question

1.00/5 (2 votes)

See more:

SQL

How to use join in sql
How to use join in sql

Posted 17-May-12 18:54pm

sharmarun

Updated 3-Apr-19 19:44pm

Add a Solution

Comments

member60 18-May-12 1:02am

Don't limit your query with this much, dig into more and try to learn more, these are the simple concepts no? better to to learn joins , different type of joins in sql and many basic thing.
Surf through google you will find every answer there , and our CP experts are always ready to help learners. hope you are agree with this.

6 solutions

Solution 4

SQL Joins[^]

Posted 28-Jun-12 19:26pm

dharan1990

Solution 6

this may also help you to find the difference between them,
Differences Between Various Joins in MS SQL Server[^]

Posted 26-Sep-14 7:12am

DiponRoy

Solution 7

There are certain types of joins, such as Inner join, outer join, Left outer join, Right Outer join, Cross Join.

Here, we will see the inner join.
If you want to have the common data from two tables then inner join is used.The query of inner join will be as follows:

Select * from Table1 Inner Join Table2 ON Table1.id = Table2.id;

Posted 3-Apr-19 19:45pm

Drasti Chavda

Comments

CHill60 4-Apr-19 4:11am

You have added nothing at all to the solutions that were posted 7 years ago. Try to make sure you are brining something new to the thread, especially old ones like this

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)

Maciej Los · Accepted Answer · 2012-05-17T19:04:00

Solution 2

More about JOIN:
http://msdn.microsoft.com/en-us/library/ms173815.aspx[^]
http://www.sqlteam.com/article/writing-outer-joins-in-t-sql[^]
http://www.w3schools.com/sql/sql_join.asp[^]

Posted 17-May-12 19:04pm

Maciej Los

Comments

Wendelius 18-May-12 1:07am

Good links! We added some links at the same time :)

Maciej Los 18-May-12 6:39am

Thank you ;)

Prasad_Kulkarni 18-May-12 1:12am

sqlteam is my favorite one. Good answer Isomac! +5!

Maciej Los 18-May-12 6:39am

Thank you ;)

VJ Reddy 18-May-12 1:44am

Good references. 5!

Maciej Los 18-May-12 6:39am

Thank you ;)

MAKReddy 29-Jun-12 1:39am

good links!my 5!

Wendelius · Accepted Answer · 2012-05-17T19:06:00

Solution 3

One quite good tutorial is found at SQL Joins[^]

Posted 17-May-12 19:06pm

Wendelius

Comments

Prasad_Kulkarni 18-May-12 1:14am

w3schools always useful, My 5!

Wendelius 18-May-12 1:26am

True :)

VJ Reddy 18-May-12 1:44am

Good reference. 5!

Wendelius 18-May-12 13:14pm

Thanks :)

Maciej Los 18-May-12 6:40am

... the same time... and the same site ;) +5

Wendelius 18-May-12 13:14pm

Yep, that happens ocasionally :)

sunandandutt · Accepted Answer · 2012-05-17T18:55:00

Solution 1

SQL

select * from table1 e join table2 e1 on e.id=e1.id

There should be a common field in both tables.

Posted 17-May-12 18:55pm

sunandandutt

Updated 17-May-12 18:57pm

v2

Comments

member60 23-May-12 5:16am

my 5 !

sharmarun 29-May-12 6:17am

my 5!

MAKReddy 29-Jun-12 1:36am

my 5!