1 reply to this topic

[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

[lespauled]

As a programming practice, you might want to start using the ON method of joining tables:

SELECT 	s.EMP_NO

		, p.SSS

		, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME

		, s.SSSLoan

		, s.SSSAmor 

FROM hris.PERSONAL p

INNER JOIN hris.employment em

ON em.EMP_ID = p.EMP_ID

INNER JOIN payroll.sssloan s 

ON em.EMP_NO = s.EMP_NO;

When you do it this way, you notice that you don't have a WHERE clause, as in: WHERE em.EMP_NO = 12345