＋设为首页 ＋添加到收藏夹
table1
id title content
1 aa a1a1
2 bb b2b2
3 cc c3c3
4 dd d4d4
.........
table2
id sid name
1 1 w
2 1 n
3 2 q
........
table2中的sid中存table1中的id,table1和table2是一对多的关系，２个表都做了全文索引，现在根据关键字在２个表中查询，要求返回tabl1的title,content,table2中对应table1的name
也就是一条记录对应多个附件的全文检索问题，请大家帮忙
select table1.title,table1.content,table2.name from table1 table2
where table1.id = table2.sid
or
select table1.title,table1.content,table2.name from table1
inner join table2 on table1.id = table2.sid
要不重复，只要保证派生的表2里的记录不重复。如：
select table1.title,table1.content,tem.name from table1
inner join (select sid,name from table2 group by sid,name)tem on table1.id = tem.sid where contains(*,关键字)
