I have two database tables that contain a product_model field. On one table, the product model starts with a prefix (TL_) and has no prefix in the other table. I want to use those fields to join a query and am having trouble figuring out how to get it working. This always returns with zero results, so it appears it is not working. See below:
SELECT a.id as app_id
applications as a
JOIN products as p
Any ideas on how to resolve the problem?