[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] need SQL help

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] need SQL help
Date: Sat, 3 May 2003 01:05:57 +0200
User-agent: Mutt/

> I think what you need is an outer join (which ensures each
> row in the table is mentioned at least once:
>  select a.substance, cn.value from allergy a left outer join clin_narrative 
> cn on (a.id_comment =;
> cn.value will be NULL is  a value is not found.

Looks about right. I'll wander off learning more about joins.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]