Do you mean tables or columns? Usually you would join multiple tables with a join statement, and then the search would search multiple columns of the joined table.
If you use the "keyword" type search in dataAssist search it will allow you to multiselect columns with a single comparison. That is probably the correct solution based on your description.