select * from [data] where id in (select id from person)
select * from data where id in (select id from person)或 select data.* from person, data where person.id= data.id
我用了一下teaism的 select * from data where id in (select id from person) 结果是可以了,不过其实我想要的是 0001,wang,hello,wang 0002,wang,bad,wang 0003,zhang,hello,zhang 后面一个字段是表person中的名子,谢谢各位了
我用的是 select data.*, person.name from person, data where person.name = data.name 可是结果却是: 0001,wang,hello,wang 0003,zhang,hello,zhang 请大家看看
select person.id*,data.name,data.word from person, data where person.id = data.id
from data where id in (select id from person)select *
from data where exists(select 1 from person where id=data.id)
建议在data表中加一个外键P_ID与表person中的ID关联,就不会出现名字不匹配的现象了。
from data where id in (select id from person)或
select data.*
from person, data
where person.id= data.id
select *
from data where id in (select id from person)
结果是可以了,不过其实我想要的是
0001,wang,hello,wang
0002,wang,bad,wang
0003,zhang,hello,zhang
后面一个字段是表person中的名子,谢谢各位了
select data.*, person.name
from person, data
where person.name = data.name
可是结果却是:
0001,wang,hello,wang
0003,zhang,hello,zhang
请大家看看
from person, data
where person.id = data.id
说得很清楚了
我想要的是
0001,wang,hello,wang
0002,wang,bad,wang
0003,zhang,hello,zhang
可结果却是:
0001,wang,hello,wang
0003,zhang,hello,zhang
from person, data
where person.id = data.id
建议在data表中加一个外键P_ID与表person中的ID关联,就不会出现名字不匹配的现象了。不是名子不匹配,是只有一条,我需要把所有的都找出来,它却只找最前面的一条
from data where name in (select name from person)
我是过了,可以实现
我想要的是
0001,wang,hello,wang
0002,wang,bad,wang
0003,zhang,hello,zhang
可结果却是:
0001,wang,hello,wang
0003,zhang,hello,zhang
from data where id in (select id from person)
where data.name in (select distinct person.name from person)