bloody SQL assignment is killing me. "List all data from the Person…: dewhitton

Log in

No account? Create an account

Remember me

By logging in to LiveJournal using a third-party service you accept LiveJournal's User agreement

: Den (dewhitton) wrote,
2002-03-31 14:24:00

Den
dewhitton
2002-03-31 14:24:00

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?

Around The World in 80 Beers Episode 210: 4 Pines Nitro Stout

Pours very black and opaque, with a small, tan head of fine bubbles. No carbonation visible First Sip: Mild malts with a slightly bitter, dark…
Around The World in 80 Beers Episode 207: Monteith's Pointers Pale Ale

</a> Pours a slightly cloudy honey colour with a small head and not much carbonation visible. First Sip: Mild, bready malt with a faint…
Around The World In 80 Beers Episode 206: Nosey Bob Red Ale

Pours a clear, dark red-brown colour. Very fine carbonation visible, with a medium head. First Sip: A lot of malt, with a lot of coffee and a…

Post a new comment
18 comments

Around The World in 80 Beers Episode 210: 4 Pines Nitro Stout

Pours very black and opaque, with a small, tan head of fine bubbles. No carbonation visible First Sip: Mild malts with a slightly bitter, dark…
Around The World in 80 Beers Episode 207: Monteith's Pointers Pale Ale

</a> Pours a slightly cloudy honey colour with a small head and not much carbonation visible. First Sip: Mild, bready malt with a faint…
Around The World In 80 Beers Episode 206: Nosey Bob Red Ale

Pours a clear, dark red-brown colour. Very fine carbonation visible, with a medium head. First Sip: A lot of malt, with a lot of coffee and a…

Log in

Around The World in 80 Beers Episode 210: 4 Pines Nitro Stout

Around The World in 80 Beers Episode 207: Monteith's Pointers Pale Ale

Around The World In 80 Beers Episode 206: Nosey Bob Red Ale

Error

Around The World in 80 Beers Episode 210: 4 Pines Nitro Stout

Around The World in 80 Beers Episode 207: Monteith's Pointers Pale Ale

Around The World In 80 Beers Episode 206: Nosey Bob Red Ale