> Any thoughts on how to solve this it wasn't real clear what you wanted 1 and 2 joined, plus 3 and 4 joined? and then combined with UNION? > and if I create two views can I create a third over the top of both? yes, usually some databases may not let you declare a UNION in a view which database are you using? rudy