Why does LEFT JOIN duplicate columns?

Question

SQL

in general, after using LEFT JOIN, I have duplicate columns

select *,
dic_type.name
from sap_ziw
left join dic_type on dic_type.Id = sap_ziw.type_id

screen in attachment

Answer 1

* - selects all fields and all tables, including those in join. You need to usesap_ziw.*, dic_type.name

Answer 2

So you yourself wrote "select all columns (*) and additionally the column dic_type.name".