I have these two tables (products and brands table) and I need to create a fulltext index to support the search function for my website. I want an index that contains the brand name and product name of a product. And for this case, the columns come from different tables.
What I know for now is creating fulltext indexes from a single or multiple columns coming from just one table.
This is the preview of the database i am currently working on: Database Preview Here