[Solved] SQL help on self Join query

Looks like you just need :

SELECT
    p.paymentid,
    p.paymentdate,
    c1.name payment_customer,
    c2.name customer
FROM 
    payment p
    INNER JOIN customers c1 ON p.cust_id = c1.paymentcustid
    INNER JOIN customers c2 ON p.cust_id = c2.custid;