Matching up queries.

[Derleek]

Ok, so i have two tables that have this information in it

 

Racers:

id|

Name

 

Race_racer: (which matches up a racer to a race)

id|

class|

race_id|

 

Now what i need to do is retrieve a name from 'racers' if it equals the id, race_id, and class.

 

Can this be done?

[bluejay002]

given that race_id is the PK of table Race_racer and id is an FK to the PK of table Racers:

 

SELECT B.name
FROM Race_racers as A
INNER JOIN Racers as B ON B.id = A.id
WHERE B.id = 'value_id_match'
AND B.class = 'value_class_match'
AND B.race_id = 'value_race_id_match'

 

cheers,

 

Jay