SELECT client_no,product,status,paid_date
FROM client_educational
LEFT JOIN client_personal ON client_educational.client_no = client_personal.client_no
WHERE product='CSM'
OR product='LSP'
OR product='CSD'

client_educational
        client_no           product         status          pd_date

        500000              CSM             pd-cert         2018-06-20
        500001              LSP             pd-cert         2018-06-20
        500002              CSD             pd-cert         2018-06-20


client_personal
        client_no           name            email           phone

        500000              John Doe       mail@mail.com    555-555-5555
        500001              John Shmoe     mail@mail.com    555-555-5555
        500002              John Howe      mail@mail.com    555-555-5555