>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?
In a general way, from a child table, you can get the parent fields by doing a INNER JOIN such as:
SELECT Parent.Name FROM Child;
INNER JOIN Parent ON Child.NoParent=Parent.Numero;
WHERE Child.Condition...