> I think the way to get the result you want is to suppress the
> null-containing rows before they get to the FULL JOIN, like so:
>
> regression=# SELECT *
> FROM (SELECT * FROM iandmed WHERE ametikoht IS NOT NULL) AS iandmed
> FULL JOIN koosseis ON iandmed.ametikoht=koosseis.ametikoht;
Thank you.
In my case koosseis.ametikoht column does not contain null values.
Si I fixed this in WHERE clause
WHERE (iandmed.ametikoht is not null or koosseis.ametikoht is not null)
I hope this produces same result in my case.
Andrus.