(no subject)

[den]

bloody 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?

Comments

[dewhitton.livejournal.com]

it's bloody access

[mmmetta.livejournal.com]

dunno about access, but my guess would be because it's comparing strings. if you compared numbers you'd be able to get away with <>, i think. if its valid syntax anyway.

[moonrose.livejournal.com]

the strings thing is my guess too. i've been lucky and managed to avoid Access for the most part. :/