I want to know the query in searching multiple tables in db? I used MySQL database.
Example I have two tables named table1 and table2. If I search some name in table1 if results not found then search in the other table table2. Is this possible?