SQL SERVER - QUERIES - FROM CLAUSE - JOIN vs NO JOIN

This video covers some of the more important theories of SQL. A join is a way of stating certain requirements in the FROM CLAUSE as opposed to writing much more confusing and convoluted code in the WHERE CLAUSE. The reason to do this is that it will make your code cleaner and tighter (easier to maintain) as well as making it much more easier to read.
 

 
By adhering to these coding standards you will have a better coding experience. The technologies that are available in both SQL (Structured Query Language) and then SQL Server's T-SQL (Transact SQL) are really in place to help you to create a more robust and clear query. Your stored procedures (SP's or sprocs or procedures), user defined functions (UDF's or functions) and trigger code will be much better and will integrate more easily with the feelings and preferences of most other typical and advanced software developers.
 

SQL SERVER COURSE - 70% OFF FOR OUR READERS

For those of you that would like to broaden your understanding of SQL Server, or if you work with someone who needs a little (or a lot of) help :), We are offering a huge discount to one of our most popular online courses. It is the lead off course which discusses tables - what to do and not do. It is very instructional, practical and straightforward.

Normally this course is $199.00, but for a limited time it is available through this offer for only $18.00!   

SQL SERVER COURSE - SAVE 70% !! SQL Server FAST TRACK for Novices - Tables Quickly master intelligent table design and management via SSMS, Queries, TSQL, Scripting and Stored Procedures.   Get Started