That's what I like about UT. You do 5 hours of work and write it up. I copy down the message # and get all the credit < eg >

Barbara

>You got that right! I blew about 5 hours trying to figure that one out. From now on I only use view designer to get first-cut SQL code. Then I cut and paste SQL into a .prg file, then modify the code to un-nest the joins. Then execute the code to create the final view.