On Wed, Dec 07, 2005 at 01:50:37PM +0100, Martijn van Oosterhout wrote:
> > from
> > v_basic_person vbp <----------
> > where
> > hxfi.fk_relative = v_basic_person.pk_identity <-----------
Duh. It got to be something simple which I just couldn't
see. Thanks for pointing that out.
> Note, one of the legs of your union has v_basic_person in the FROM but
> doesn't use it. The effect is probably hidden due to your use of UNION
> rather than UNION ALL.
Fixed, too.
How wonderful a resource this list is.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346