try:
create view v_name as
select * from tabl1,tabl2
where table2.bigname like '%'||table1.smallname||'%';
create view v_name as
select * from tabl1,tabl2
where table2.bigname like '%'||table1.smallname||'%';
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||'%';
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)
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||'%';