rudy wrote: > it wasn't real clear what you wanted > > 1 and 2 joined, plus 3 and 4 joined? and then combined with UNION? As an addendum I think my problem was trying to union 1 & 3 / 2 & 4 then join - would that have made any difference? -- Christopher Joseph ------------------- [Internet] http://www.ideadesigners.com [iseries & web technologies] mailto: christopher at ideadesigners.com [Telephone] mobile: +44 7966 003860 Office: +44 1494 731814 ext. 832 Direct: +44 1494 731832 [Instant Message] ICQ: 78019724 YIM = Josephc_98 MSN = christopher at ideadesigners.com