tengo cuatro tablas:
tabla 1 nombre,email
tabla 2 idCampaña,nombreCampaña
tabla 3 fkCampaña,otroEmailUno
tabla 4 fkCampaña,otroEmailDos @Xique

dato1tabla1 dato1tabla3 dato1tabla4
dato2tabla1 dato2tabla3 dato2tabla4
dato3tabla1
dato4tabla1

este es el query
SELECT
subscribers.full_name AS "FULL NAME",
subscribers.email AS "EMAIL",
campaign_name.nb_campaign_name AS "CAMPAIGN NAME",
campaign_sentto.nb_campaign_email AS "SENT TO",
campaign_opened.campaign_opened AS "OPENED"
FROM
public.subscribers,
public.campaign_name,
public.campaign_sentto,
public.campaign_opened
WHERE
subscribers.id_subscribers = campaign_name.id_campaign_name AND
campaign_name.id_campaign_name = campaign_sentto.fk_campaign;