Huh? I didn't quite understand your question. If you wonder whether it is possible to have a column that return one of several values, then you could do something like COALESCE(t1.NUMPAT, t2.NUMPAT) and it would return NUMPAT of t1 if any, and if this was NULL it would return t2.NUMPAT.

If this doesn't help, think through your question again and ask in a way that makes it easier to understand (e.g. showing some SQL).

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Alejandro Garcia
Sent: 6. september 2007 10:24
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Full join

Hi, I'm trying to full join to tables with this structure:
NUMPAT CTRACT DATA ITEM1, ITEM2...
and I'm joining them on NUMPAT and CTRACT but I need all the NUMPAT to appear at the rigth of the result, now when I full join them the first table NUMPATs appear at the right and the rest appear with null value because they do not join to any of the second table, but I need them all to appear at the rigth of the result..could this be done? thanks in advance