SELECT t2.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferF & 
        (
            ' ' + tblClients.client_name +' '+tblClients.client_midname
        ) 
        AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
            tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='2'
    )  
    AS t2 
    INNER JOIN tblOffParams ON t2.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101
UNION ALL
SELECT t1.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferM & 
        (
            ' ' + tblClients.client_name +' '+tblClients.client_midname
        ) 
        AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
        tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='1'
    )  
    AS t1 
    INNER JOIN tblOffParams ON t1.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101
UNION ALL
SELECT t0.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferNot AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
            tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='0'
    )  
    AS t0 
    INNER JOIN tblOffParams ON t0.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101