query two tables, but display fields from one table

[gogaak]

helo al,

I have two tables
Employee

• TokenID (PK)

• name

• location

• post

• ..

• ..etc

Rating

• TokenID (PFK)

• FinalScore

I am trying to display all the fields from Employee table where Employee.TokenID= Rating.TokenID
but I only want to display the fields from the Employee Table and not from the rating table.
And each record displayed should be distinct by the TokenID

Please do help
Thank you

 

[EMP]

Try this query:-

Select *
from Employee
Where TokenID in (Select TokenID from Rating)

,

 

[gogaak]

Try this query:-

Select *
from Employee
Where TokenID in (Select TokenID from Rating)

,

Thanx a lot
it works perfect.