JOIN? Help

[AnAmericanGunner]

I *think* this is a JOIN situation, but I'm not sure.

 

Here's the deal.

I have a table (masteroffspring) that essentially contains two bits of information:

horseid | foalid

 

These ids are to correspond with the masterhorse table, which contains all the information.

I need a script that does the following, on a page that already has a query for the masterhorse table.

 

It needs to search the masteroffspring's horseid and find any/all matches, and then look at the foalid and pull the foalid information from the masteroffspring and list the results in a table.

 

Does that make sense? Please help.

Thanks.

[fenway]

Yup, it's a JOIn.