drop view if exists comm_search; create view comm_search as select *, 0 as square_unit, 'comm' as search_base from comm union select *, 'zem' as search_base from view_comm_from_zem;