Not sure I understand what you're saying.
Originally posted by cpt_azad
@6 May 2004 - 01:33
one thing i still don't understand is why 4) "Can multiple conditions be used in the WHERE clause?" is answered as yes, it seems to make sense, but i don't know why that is same as number 2).
Single quotes (' are neccessary for everything except number, I believe. When they use
the EMPLOYEE_ID field has been defined as a char, not a number. Otherwise
WHERE EMPLOYEE_ID = '333333333'
would be used.
WHERE EMPLOYEE_ID = 333333333
And for 4), this is a valid clause:
Multiple conditions certainly can be used in the WHERE clause.
WHERE EMPLOYEE_ID = '333333333' OR EMPLOYEE_ID = '333333334'