Creating a table from 2 other tables

I am trying to create a 3rd table (table c) that will present all names has a "Full Name" column from table a, and will list all the names under "DISPLAY_NAME" from table b, and the LICENSE_NO column...