Hi, i am currently making a search function for a project. the database has for tables namely
events
promos
store_locator
watches
so how do i join these tables so that when i enter a search term, it would search all for tables and display the results?