Table A

ID | Name | etc


Table B

ID | ItemID (references to A.ID) | etc

Get Name from A referenced by B.ItemID