search string from two tables without union single query : <p>I have two table one for activity and another for pages(to store pages created by users), I want to search results based on Activity content as well as page. In result I want records matches the activity content or page title. pages are associated with activity as entity_id(page_id). Please suggest without union as I want to use pagination as well.Thanks</p>
