[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams |
Date: |
Fri, 19 Feb 2010 23:02:57 +0100 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
On Fri, Feb 19, 2010 at 09:51:24AM -0800, Jim Busser wrote:
> Also I suppose
>
> SELECT DISTINCT
>
> is not right for this situation (?)
Technically valid (you are telling the select to only return
distinct rows) but it doesn't solve the problem of having to
find the MAX of HISTORY_DATE per group of DRUG_CODE.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, (continued)
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
- Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams,
Karsten Hilbert <=
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/19
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/19
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/20
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/21
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Jim Busser, 2010/02/21
Message not availableRe: [Gnumed-devel] Getting Canadian drug data into FreeDiams, Karsten Hilbert, 2010/02/23