(no subject)
31 March 2002 14:24![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
denbloody SQL assignment is killing me.
"List all data from the Person table who are niether staff nor patients."
fucked if I know.
Why does
WHERE person.person_id = staff.person_id
AND person.person_id = admission.patient_id
work and
WHERE person.person_id <> staff.person_id
AND person.person_id <> admission.patient_id
not?
"List all data from the Person table who are niether staff nor patients."
fucked if I know.
Why does
WHERE person.person_id = staff.person_id
AND person.person_id = admission.patient_id
work and
WHERE person.person_id <> staff.person_id
AND person.person_id <> admission.patient_id
not?
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
Re: Try this
Date: 31 Mar 2002 05:19 (UTC)