Search query using multiple tables

@palmer,

Are you familiar with database views? You could create a view that has all of the mentioned data that is searchable?

Or

You could create a complex query that has all of the searchable content by using a specific SQL join.