Issue in Select Statement

[newphpcoder]

Hi...

i had encountered problem in my select statement..

here is my query:

SELECT s.EMP_NO, p.SSS, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME, s.SSSLoan, s.SSSAmor FROM hris.PERSONAL p, hris.employment em, payroll.sssloan s WHERE em.EMP_ID = p.EMP_ID AND em.EMP_NO = s.EMP_NO;

the output of this query is all data in SSSLoan was displayed..I want to display only is the employee that i choose.

Thank you

[bradgrafelman]

Well it's obvious why all employee records are displayed... you've never specified any criteria in the WHERE clause that would target a specific employee's record(s).