SQL "not in" question?

SQL "not in" question?

select bednr from bed
where bednr not in (select distinct bednr from patient);

This does not seem to work. Its basicly to see if a bed is in use or not.

select bednr from bed
where bednr not in (select distinct bednr from patient
where bednr is not null);

This entry was posted on Tuesday, December 8th, 2009 at 7:58 pm and is filed under select distinct. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL "not in" question?”

Serge M on December 9th, 2009 at 1:22 am

select bednr from bed
where bednr not in (select distinct bednr from patient
where bednr is not null);
References :
http://www.sql-ex.ru/

Leave a Reply