I have one master table (customers), and two sub-tables containing customer data for 1) travels and 2) catalogueorders.
The structure is different, so concatenation is not possible.
We need to extract data from master table depending on if there is data with certain criteria both for 1) and 2). The choices made for table 1) must not restrict choices for table 2). Is this possible? The important thing is not to get doubles from master table.
