Hello, i would like to know how to do this:

i have two tables CV(curriculim vitae of the animal) and SEMENSALES(sales of semen, contain information of which horse provide an insemination to a mare), in SEMENSALES i have two main fields IDMare and identification for the query and on CV i have identification, so, basically i need to do a query that tells me the name of the mare and the name of the horse that provides the semen for insemination, how can i do this?

Thanks for the help