Find out the content of one field in the table contains another field, how to write ???

rbaggio110

There are two tables A, B
Form A: (standard form)
nname, city, adress
Form B:
mname, sds,
The purpose I want to achieve is to find out that the mname field in table B contains the data of nname field of table A. Get table C:
mname, sds, nname, city, adress fields mname contains nname field

fanfan1980

--try
select * from A, B
where A.nname = B.mname

sinexe

select *
from B _b
join A _a on _b.name like '%' + _a.name + '%'

wgfxman

select mname, sds, name, city, address from A, B
where A.name = B.mname

恶魔右指

select a.name, b.name from a, b where charindex (a.name, b.name)> 0--the name of table B contains A.name

不悔不牛

select b.mname, b.sds, a.nname, a.city, a.adress
from a, b
where b.nname = a.mname

terrorlin

insert into c select * from an inner join b on b.name like a.name | '%';

rbaggio110

One more sentence, if 'ALAM INFORMASI TEKNOLOGI', I want to take the first two words, how to write it?