Hi,
I have 2 tables that contain information about company assets. Essentially these two tables are describing the same assets but they have their own conventions so they may have slightly different asset names.
Additionally they both have information about their location stored in terms of distance along a route name. There are several different possible routes.
Firstly I want to join the tables by route name.
Then I want to join by PLANT_NO. The PLANT_NO are different between these tables but generally they will contain a portion of the name from one table within the other table.
I tried this to just do the second part for now (will try the join by route name after) but no records were returned..
SELECT *
FROM TABLE_A
INNER JOIN TABLE_B
ON TABLE_A.PLANT_NO=TABLE_B.PLANT_NO
WHERE TABLE_.PLANT_NO LIKE '*[TABLE_B.PLANT_NO]*'
Any help would be greatly apprecaited.
Thanks,
Rob.