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
