• Thanks for replying.

    i am pulling ext from the MySQL view which in also in the EMP SQL table.

    Based on the EXT i need to get dept, fname, lname, empum from thenSQL table