Three Tables INNER JOIN and WHERE Clause

Three Tables INNER JOIN and WHERE Clause

References

Reference NO 1

http://stackoverflow.com/questions/15188234/three-tables-inner-join-and-where-clause

Reference NO 2

http://stackoverflow.com/questions/15099019/mysql-joining-multiple-table-where-clause-issues

Reference NO 3

http://www.dbforums.com/microsoft-access/1617402-correct-syntax-inner-join-multiple-tables.html

Reference NO 4

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473691.htm

Reference NO 5

http://psoug.org/reference/joins.html

Reference NO 6

http://forums.devshed.com/ms-sql-development-95/sql-query-using-multiple-counts-with-where-clauses-and-inner-897256.html

Reference NO 7

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

Reference NO 8

http://bytes.com/topic/visual-basic-net/answers/352469-using-inner-join-3-tables