left join on multiple columns code example

Example 1: python inner join based on two columns

df  = pd.merge(left=df1, right=df2, on=['var_1', 'var_2'], how='inner']

Example 2: how to select all the field of the left join table

SELECT nutrients.*, measures.colX
FROM nutrients 
LEFT JOIN measures ON nutrients.name=measures.name