actually it should be a LEFT OUTER JOIN now that I think about it. That way if a record is not returned in one case it will inslude the record for the other cases.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.