Is it possible to do this:

In a single query, join a row within a table based on a column with unique stock number, with a targeted row within within a group of rows with the same stock number in another table?

If so how do you target the non unique row?