Subject UNION capabilities
Author Lester Caine
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 -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -