I need to get a column value from another table field nonetheless the the key used in on of the table is different to the another key in the another table.
Table 1 Inventory
Table 2 Supervisor
This is a similar kind of table that I have, I need to basically pull the supervisor name to show in the Table 1 Inventory.
How ever since both keys are different I wont be able to pull the supervisor name associtate to the warehouse.
Note: Warehouse are numeric fields