I wonder if someone might be able to help me with my aggregate design, please?

I have the following tables

SMS_History
Type (Referral or standard)
Phone_Number
DateTime_Sent
Content

Referral_Leaflets
Link URL
Name

Customers
Name
Number

Standard_Leaflets
Link URL
Name

The SMS_History table contains a list of all the messages ever sent. Every record in the SMS_History table will have a corresponding entry in the customers table.

The SMS_History table, will either refer to a Referral_Leaflet entry OR a Standard_Leaflet entry.

I wish to create an output like this:

Datetime_Sent | Customer Name | Type | Detail
10/05/2022 @ 1920 | Mr Smith | Referral | Service 1
10/05/2022 @ 1900 | Mr Singh | Standard | Link 1

I obviously have all four tables in the aggregate, and have set the joins like this:

Sms_History.number = Customers.Number (Only with)
Sms_History.Content like "%" + Referral_Leaflets.Link + "%" (With or without)
Sms_History.Content like "%" + Standard_Leaflets.Link " "%" (With or without)

This doesn't work...

It gives an output like this:

Datetime_Sent | Customer Name | Type | Detail
10/05/2022 @ 1925 | Mr Smith | Referral | Service 1
10/05/2022 @ 1925 | Mr Smith | Referral | Service2
10/05/2022 @ 1925 | Mr Smith | Referral | Service3
10/05/2022 @ 1920 | Mr Singh | Standard | Service 1
10/05/2022 @ 1920 | Mr Singh| Standard| Service 2
10/05/2022 @ 1920 | Mr Singh | Standard | Service3

I would appreciate any direction.

Thank you