select multiple tables with condition in sql query

select multiple tables with condition in sql query

References

Reference NO 1

http://stackoverflow.com/questions/7647306/sql-query-to-select-multiple-column-from-two-table-based-on-a-condition

Reference NO 2

http://stackoverflow.com/questions/8569637/sql-query-to-select-from-two-tables-with-if-condition

Reference NO 3

http://www.sql-ex.ru/help/select5.php

Reference NO 4

https://kb.askmonty.org/v/select-statement/

Reference NO 5

http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001361644.htm

Reference NO 6

http://docs.oracle.com/cd/E17781_01/appdev.112/e18147/tdddg_selecting.htm

Reference NO 7

http://msdn.microsoft.com/en-us/library/f4saeycb(v=vs.80).aspx

Reference NO 8

http://www.dbforums.com/ansi-sql/1616636-sql-query-select-multiple-tables.html