所涉及的表结构:
HR方案下的regions、countries,表结构如下:
创建连接视图v_regions_countries,包含字段r_id,r_name,c_id,c_name。视图从regions表、countries表查询出region_id、region_name、country_id、country_name字段。
正确答案:
Create view v_regions_countries
As
Select region_id、region_name、country_id、country_name
From HR.regions,HR.countries
Where r-id=c_id;r_name=c_name;
As
Select region_id、region_name、country_id、country_name
From HR.regions,HR.countries
Where r-id=c_id;r_name=c_name;
答案解析:有

微信扫一扫手机做题