Does each section of a UNION have to be complete?

By that I mean - I have a UNION which combines three sets of data grouped by
staff_id, and I'm currently doing the JOIN for giving the name in each section.
Is there a way to add the name lookup to the result. I keep getting errors when
I've try it myself and so I wonder if I'm stuck with three separate loins, or is
there another way to do it?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php