I would love if someone could help me with this.
I have 3 tables
Table1 Table2 Talbe3
(They are almost the same, but however some columns are slightly different)
What I wanted to ask you is how do I display all results from all 3 tables (including rows and columns) on a webpage.
Also how do I make the search bar look through all 3 tables.
For example, if I someone searches by First name or Last Name ("An") So the results display rows from all 3 tables that contain "An" for example (Annete, Andrew, Anamari, Andrea) etc.
Thank you