FROM_NUMBER TO_NUMBER
123               321
222               111
333               123

PHONE  NAME
123    Bill

SELECT a.FROM_NUMBER, a.TO_NUMBER, b.NAME, c.NAME FROM audit a
   LEFT JOIN address_book_contact b
      ON (a.FROM_NUMBER=b.PHONE)
   LEFT JOIN address_book_contact c
      ON (a.TO_NUMBER=c.PHONE)

123 321 Bill null
222 111 null null
333 123 null Bill

123 321 Bill Bill
222 111 null null
333 123 null null

package foo;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;


public class JoinTest {

    private SessionFactory sessionFactory;

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    public static void main(String[] args) {
        ApplicationContext ctx = new ClassPathXmlApplicationContext("spring/jointest.xml");
        JoinTest client = (JoinTest) ctx.getBean("JoinTest");
        client.test();
    }

    private void test() {
        String q = "SELECT a.*, b.CONTACT_ID, b.CONTACT_NAME, c.CONTACT_ID, c.CONTACT_NAME FROM audit a LEFT JOIN address_book_contact b" +
                " ON a.FROM_NUMBER=b.PHONE LEFT JOIN address_book_contact c ON a.TO_NUMBER=c.PHONE ";
        Session s = sessionFactory.openSession();
        Query query = s.createSQLQuery(q);
        List result = query.list();
        System.out.println(result);
    }
}