Below are my tables. My problem is that i need [item_status] from Table A and [LatLong] from table B to show up in my map view. The issue has been that Table A [Inventory_item_id] does not equal to Table B [Asset ID]. The ids are different:
Table A ID - 145
Table B ID - 00000145
So i needed to some how compare and match those ids first, then show on my map - [LatLong] from Table B and the corresponding Item_status for that Asset ID the [Item_status] from Table A.