Chris,
I'd LOVE to see a 'left-right-outer' join! But I agree that left/right and inner/outer joins are a pain in the..... typing fingers :-) But the view designer is useful for selecting fields, doing simple parameterized views, etc.

Barbara

>Thanks to everyone for all the help - I don't know if it's just me, but it's really difficult getting a handle on the "inner-right" join Vs the "left-right-outer" join Vs the "left-right-out" join stuff in the wizard.
>
>I think I'll stick the manual way from now on.
>
>Cheers
>
>
>Chris