Merge Question Between Data Tables with Shared Column

Hi Sergei,

Thanks for the reply. To clarify things, please see a screenshot of the first table named "WO":

As you can see there are two columns "WO_Description_ID" and "Findings_ID". There are for the most part sequential but the same numbering scheme. Each row is associated with a unique work order.

The second table below is in the same database and titled "WO_Remarks":

This has the first column where the "description ID" and "findings ID" from above have all been collectively dumped in a single column. I am after the content of the "remarks" column above but need to extract this text using the uniqe "ID" identifier. Since it is done this way, every row of the first table will correspond to two rows of the second table (one row for description and one for findings remark text).

How can I extract this data from the second table and tie to the correct individual row of the first table?

Thank you,

Rob