Link Contains Example Of Joins , Multiple Case Statement , Subquery Join

Subquery Rules
- http://technet.microsoft.com/en-us/library/ms189543(v=sql.105).aspx

CASE STATEMENT Examples
- http://technet.microsoft.com/en-us/library/ms181765.aspx

EXISTS Examples
- http://technet.microsoft.com/en-us/library/ms188336.aspx

Subquery Examples
- http://technet.microsoft.com/en-us/library/ms189575(v=sql.105).aspx

COALESCE Examples
- http://technet.microsoft.com/en-us/library/ms190349.aspx

Query Example Coming Soon ...