Click here to Skip to main content
15,847,549 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi As I'm newbie in SQL server please let me know the use of joins in real
Time scenario with a simple example which explains the advantage of using joins
Posted

Have a look here: sql_join[^]
It is more than real time scenario.
 
Share this answer
 
Basicaly the idea is that joins are used to link two ore more tables together so that the query will return correctly (typically) master-detail data.

Few basics:
- Join Fundamentals[^]
- Using Joins[^]
 
Share this answer
 
v3
Comments
siva455 16-Mar-11 13:51pm    
As I already requested Pls give me a sample with real time scenario
Wendelius 16-Mar-11 13:55pm    
The links contained few samples how to use joins, but perhaps this explains it more thoroughly: http://en.wikipedia.org/wiki/Sql_join
siva455 16-Mar-11 13:52pm    
Provided 2 links were locating to same url
Wendelius 16-Mar-11 13:58pm    
Sorry, simple paste error. Corrected.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900