joing three tables in sql??

Hi,

Can you help me with joing three tables please?

I am doing freetext in sql server database.
I just want to list everything with this search word in it.
Say I have these three tables.

project(projectid,projectname)
projectpeople(projectid,peopleid)
people(people,lastname,firstname)

I have thse two queries from each table but I am not sure how I should merge two result tables.

select projectid,projectname
from project inner join projectpeople on project.projectid = projectpeople
where freetext(projectname,@searchword)

select peopleid,lastname,firstname
from people inner join people.id = projectpeople.peopleid
where freetext(lastname,@searchword) or freetext(firstname,@searchword)

I just want to list these two results in one table.
projectid,projectname,lastname,firstname,peopleid


Do I even need to use the linking table(junction table) in this case?
Thanks much.Start Free Trial