表A
ibh vcmc
1 AAA
2 BBB
3 CCC
4 DDD 表B
iibh ibh1 ibh2
1 1 2
2 2 3
3 1 4
4 2 4
需生成视图如下:
iibh ibh1 name1 ibh2 name2
1 1 AAA 2 BBB
2 2 BBB 3 CCC
3 1 AAA 4 DDD
4 2 BBB 4 DDD 在ms sql 中视图生成语句为:SELECT dbo.b.iibh, dbo.b.ibh1, dbo.a.name AS name1, dbo.b.ibh2,
a_1.name AS name2
FROM dbo.a INNER JOIN
dbo.b ON dbo.a.ibh = dbo.b.ibh1 INNER JOIN
dbo.a a_1 ON dbo.b.ibh2 = a_1.ibh
对ORACLE 刚接触,不懂,麻烦过来人出手
ibh vcmc
1 AAA
2 BBB
3 CCC
4 DDD 表B
iibh ibh1 ibh2
1 1 2
2 2 3
3 1 4
4 2 4
需生成视图如下:
iibh ibh1 name1 ibh2 name2
1 1 AAA 2 BBB
2 2 BBB 3 CCC
3 1 AAA 4 DDD
4 2 BBB 4 DDD 在ms sql 中视图生成语句为:SELECT dbo.b.iibh, dbo.b.ibh1, dbo.a.name AS name1, dbo.b.ibh2,
a_1.name AS name2
FROM dbo.a INNER JOIN
dbo.b ON dbo.a.ibh = dbo.b.ibh1 INNER JOIN
dbo.a a_1 ON dbo.b.ibh2 = a_1.ibh
对ORACLE 刚接触,不懂,麻烦过来人出手
a_1.name name2
FROM dbo.a,dbo.b,dbo.a a_1
where dbo.a.ibh = dbo.b.ibh1
and dbo.b.ibh2 = a_1.ibh;
a_1.name ?可以这样吗?提示找不到表,视图
a_1.name AS name2
FROM a INNER JOIN
b ON a.ibh = b.ibh1 INNER JOIN
a a_1 ON b.ibh2 = a_1.ibhORACLE9I开始支持inner join 等