Issue with left join

Issue with left join

References

Reference NO 1

http://stackoverflow.com/questions/333771/mysql-left-join-problem-missing-left-column

Reference NO 2

http://stackoverflow.com/questions/4983544/count-and-left-join-problem

Reference NO 3

http://www.xaprb.com/blog/2009/04/08/the-dangerous-subtleties-of-left-join-and-count-in-sql/

Reference NO 4

http://www.daniweb.com/web-development/databases/ms-sql/threads/236427/left-join-problem

Reference NO 5

http://www.webmasterworld.com/forum88/9654.htm

Reference NO 6

https://drupal.org/node/124325

Reference NO 7

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/74547856-a445-4b54-a980-ca39b1284fdd/action?threadDisplayName=problems-with-left-join

Reference NO 8

#EANF#