Well im looking for results for the keyword searched in content table, category table and product table.
So to add them all together and have data assist find keywords in each in 1 combined result, i would have to union them together right? Because there is no same columns that i can join each table to each other..