Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 learn together?

Author  Topic 

sqlclarify
Yak Posting Veteran

56 Posts

Posted - 2008-12-29 : 20:14:16
Hello,

I am working on Sql queries. Unfortunately I am having a hard time understanding these joins... still!!! Is there anyone who would like to study together?

If not, could somebody refer some books /tutorials with lots of examples so I can digest this stuff.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2008-12-29 : 21:08:43
There's a good set of tutorials here:

http://www.w3schools.com/sql/default.asp
Go to Top of Page

sqlclarify
Yak Posting Veteran

56 Posts

Posted - 2008-12-30 : 00:46:50
I tried this website. I guess I need spoon feeding with more lots more examples. Ugghhhh..
Go to Top of Page

sqlclarify
Yak Posting Veteran

56 Posts

Posted - 2008-12-30 : 00:47:26
I need more examples on joins and queries
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-30 : 00:54:26
http://www.sqlteam.com/article/writing-outer-joins-in-t-sql
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-12-30 : 01:51:03
Check http://en.wikipedia.org/wiki/Join_(SQL) , this will give you some basic examples illustrating the theory

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2008-12-30 : 07:46:14
One of my favorite books on SQL is Professional SQL Server 2005 Programming by Robert Vieira. I like this book not for its depth, or breadth, and not because there aren't other books that cover the same topics, but because it is fun to read; he has a nice sense of humor. In other words, it has "Readability".
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-12-30 : 10:31:27
BOL has a ton of examples as well - look up joins. Written by the "experts".....

Terry
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-12-30 : 11:00:05
I'll put in a plug for Rudy's book:
http://www.amazon.com/Simply-SQL-Rudy-Limeback/dp/0980455251/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1230652777&sr=8-1

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page
   

- Advertisement -