Gerhardus,
full join makes no sense when you only select from one of the tables! What
I suspect you're after is a UNION, i.e.

select
Diary_Date,
Department,
Darno_Rono,
ScreenName,
ProductionReworkCycle,
JobDescription,
DateCompleted,
Diary_Count
from Diary_SelectB(:In_Date,:In_User)
UNION
select
Diary_Date,
Department,
Darno_Rono,
ScreenName,
ProductionReworkCycle,
JobDescription,
DateCompleted,
Diary_Count
from Diary_SelectA(:In_Date,:In_User)

HTH,
Set

At 11:07 10.12.2002 +0200, you wrote:

>Hi
>I have the following query:
>select
> B.Diary_Date,
> B.Department,
> B.Darno_Rono,
> B.ScreenName,
> B.ProductionReworkCycle,
> B.JobDescription,
> B.DateCompleted,
> B.Diary_Count
>from Diary_SelectB(:In_Date,:In_User) B full join
>Diary_SelectA(:In_Date,:In_User) A on A.Department=B.Department

...

>The two procedure results I join does not have any rows in commen. I just
>want to glue together two
>resultsets.

...

>Diary_SelectA and Diary_SelectB have exactly the same output paramters.