Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams

[Karsten Hilbert]

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