求一视图

[tiger341]

我现有2张表:table1(id,smallName,address,tel),table2(id,bigName,money)
其中table1.smallName的值是table2.bigName里面的值的一部分,可以通过"like"找到对应的记录
现在想把上面2张表,通过table1.smallName,table2.bigName的关系来建立一个试图

[bzszp]

try:
create view v_name as
select * from tabl1,tabl2
where table2.bigname like '%'||table1.smallname||'%';

[zmgowin]

id列有重复列名，创建视图的时候需要分别命名

create view view_name
as
select
a.id id1,a.smallname,a.address,a.tel,b.id id2,b.bigname,b.money
from
table1 a,table2 b
where table2.bigname like '%'||table1.smallname||'%';

[qiaozhiwei]

create view view_name
as
(select tb1.id,tb1.smallName,tb1.address,tb1.tel,tb2.id,tb2.bigName,tb2.money
from tb1,tb2
where INSTR(tb1.smallName,tb2.bigName) <> 0)

[bsccxf]

create view view_name
as
select
a.id id1,a.smallname,a.address,a.tel,b.id id2,b.bigname,b.money
from
table1 a,table2 b
where table2.bigname like '%'||table1.smallname||'%';

[zhangzhidong2002]

up....

[ORARichard]

to 楼主，好象这个问题你在SQL Server中也问了吧，怎么，你要两种数据库都要开发？