[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Statistics
|
From: |
Karsten Hilbert |
|
Subject: |
Re: [Gnumed-devel] Statistics |
|
Date: |
Fri, 8 Feb 2013 23:51:08 +0100 |
|
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Fri, Feb 08, 2013 at 11:47:17PM +0100, Karsten Hilbert wrote:
> or even
>
> AND
> c_e.fk_type = (select pk from clin.encounter_type where description IN
> ('seen in clinic', 'seen elsewhere', 'not seen but called', ...))
> ...
Make that
AND
c_e.fk_type IN (select pk from clin.encounter_type where description IN
('seen in clinic', 'seen elsewhere', 'not seen but called', ...))
...
(not the first IN)
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346