get left table all fields and right table selected columns data only using sql joins code example

Example: 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