I have two related tables that both can be searched. In the results table I'd like to show the found records of both tables in one single list.
As far as I know, I need to have a third table for this; a table that gathers the results from table A and table B. However, I am stuck on that and am looking for a hint where to start. Any idea?