How to use Join for two tables that have related data but in different column names I have to create an sql code to combine all the tables but when im using join, its creating another instance of the same column that's existing in both tables along with the column that is not. How can i only get the column that is not in table 1?

For example
In table 1 I have


FORMID 
STATUS 
TITLE 
DESCRIPTION


In table 2 I have


HSID 
FORM ID


when I use join I get the following output:

FORMID - STATUS - TITLE - DESCRIPTION - HSID - FORMID_1


Eg. CODE:

SELECT * 
FROM PROJECT_FORM 
JOIN ASSIGNMENT
    ON PROJECT_FORM.FORMID=ASSIGNMENT.FORMID
You have to specifically list the columns you are interested in, rather than simply stating *

The first table can remain like this:
SELECT PROJECT_FORM.*, …
then you list the columns you require from the other table one by one.

SELECT PROJECT_FORM.*, ASSIGNMENT.HSID
FROM PROJECT_FORM
JOIN ASSIGNMENT ON PROJECT_FORM.FORMID=ASSIGNMENT.FORMID