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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Queries having joins in select statement

Author  Topic 

ayadav0984
Starting Member

21 Posts

Posted - 2011-01-29 : 06:46:41
Can anybody provide me examples about how to use complex sql queries having join functionality in select statement. what all things do we need to keep in mind before writing such queries.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2011-01-29 : 08:50:15
Start simple. Master the basics first. Complexity is only a frame of reference and a matter of perspective. Based on your question, I am guessing a simple query with a join would be more than complex enough...

The best way to learn, is to DO and learn from your own mistakes, and come here for help when you are stuck.

http://msdn.microsoft.com/en-us/library/ms167593.aspx

http://en.wikipedia.org/wiki/Join_%28SQL%29





Poor planning on your part does not constitute an emergency on my part.
Go to Top of Page
   

- Advertisement -