New to SQL and looking to get help with Inner Join.

How do i keep all the existing fields in the table i'm joining to? I'd just want to add the select fields from the other table.

Looking to Join

From Name (table)

Full_Name
Full_Address
Title
Company
Email

Join to Activity (Table)

keep all the fields on this table.

Can this be down?

please do a SHOW CREATE TABLE for each table