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
In table 2 I have
- FORM ID
when I use join I get the following output:
FORMID - STATUS - TITLE - DESCRIPTION - HSID - FORMID_1
SELECT * FROM PROJECT_FORM JOIN ASSIGNMENT ON PROJECT_FORM.FORMID=ASSIGNMENT.FORMID