Concatenating two field names from different tables using INNER JOIN during UPDATE statement.
I am trying to concatenate two field names in a mysql update statement.
This is what I have so far, needless to say it isn't working, any suggestions would be much appreciated.
UPDATE products INNER JOIN sub_categories ON sub_categories.id = products.sub_category SET slug = replace(trim(lower(sub_categories.subcat_name).(products.product_name)), ' ', '-');