create sql view myview remote connection myconnection [share] as ; select ... from mytable1 where ... ; union ; select ... from mytable2 where ... ; order by ... group by ...The fields in the both Select lists have to be identical types, and the order by and group by clauses can only be placed at the end of the union. To make the view updatable, you can dowlnload Erik Moore's EVIEW file to finish the view design.