Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Issue in Select Statement
12-20-2011, 02:13 AM #1
- Join Date
- Aug 2010
- Thanked 0 Times in 0 Posts
Issue in Select Statement
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;
12-20-2011, 07:24 AM #2
> I want to display only is the employee that i choose
Fine. Then put in some code to choose one.
NOTHING in that query is choosing only one employee.
Nothing is even looking like you are trying to choose only one employee.
I can't even guess how you want to specify the one employee you want to display.
Will you choose him/her by EMP_ID? By EMP_NO? By SSS? By FULLNAME?
Not a clue do you give us.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.