How to query multiple tables in Oracle

See more:

SQL

Oracle

Hello there,

I have working sql here (Oracle database): this includes masterfile table & multiple monthly tables with same schema

SELECT A.PERSONNELIDNO, A.LASTNAME, A.FIRSTNAME, A.MIDDLENAME, A.POSITIONCODE, A.SECTIONCODE, C.DESCRIPTION, A.DEPARTMENTCODE, A.EMPLOYMENTSTATUS, A.STATUSENDDATE, C.INCUMBENT AS OCNAME, tbl8.SECTIONCODE AS OCT15, tbl7.SECTIONCODE AS OCT31, tbl6.SECTIONCODE AS NOV15, tbl5.SECTIONCODE AS NOV30, tbl4.SECTIONCODE AS DEC15, tbl3.SECTIONCODE AS DEC31 
FROM CMFPA A, CLKSECTION C, MONTHLYFILE101514M tbl8, MONTHLYFILE103114M tbl7,
MONTHLYFILE111514M tbl6, MONTHLYFILE113014M tbl5, MONTHLYFILE121514M tbl4, MONTHLYFILE123014M tbl3 
WHERE A.SECTIONCODE=C.SECTIONCODE AND A.PERSONNELIDNO=tbl8.PERSONNELIDNO AND A.PERSONNELIDNO=tbl7.PERSONNELIDNO 
AND A.PERSONNELIDNO=tbl6.PERSONNELIDNO AND A.PERSONNELIDNO=tbl5.PERSONNELIDNO AND A.PERSONNELIDNO=tbl4.PERSONNELIDNO AND A.PERSONNELIDNO=tbl3.PERSONNELIDNO  ORDER BY A.DEPARTMENTCODE,C.INCUMBENT,A.SECTIONCODE,A.POSITIONCODE

Now the output looks like this and I just hide the other columns:

NO	PERSONNELIDNO	SECTIONCODE	DESCRIPTION	DEPARTMENTCODE	EMPLOYMENTSTATUS	OCT15	OCT31	NOV15	NOV30	DEC15	DEC31
1	0300018104	909	FIELD SERVICE	909	REGULAR	909	909	909	909	909	909
2	0300058255	539	TAYUMAN	909	REGULAR	148	148	148	539	539	539
3	0300005793	539	TAYUMAN	909	REGULAR	481	481	481	481	481	481

Now, how to include in the list if an employee has no entry in one table for ex. tbl8

Any help?