How do you create single lookup transformation using multiple tables?

Write a override sql query. Adjust the ports as per the sql query.
By writingSQL override and specifying joins in the SQL override.