Oh yes, sorry, it's a typo - corrected

>OPEN DATABASE ....
>CREATE SQL VIEW cddl2 ;
> AS select * from company_list ;
> union select * from division_list ;
> union select * from department_list ;
> union select * from location_list
>USE cddl2
>BROWSE
>