rudy wrote: > it wasn't real clear what you wanted > > 1 and 2 joined, plus 3 and 4 joined? and then combined with UNION? Yes - exactly that. > some databases may not let you declare a UNION in a view > > which database are you using? DB2 on iSeries (UDB2/400) ...guess maybe I am on my own with the manual with that one :) -- 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