How do the field values from the right table behave in the result of a LEFT JOIN when there are no matching records in it?

When performing a LEFT JOIN in SQL, the result contains all records from the left table, and only matching records from the right table based on the join condition. If there are no matching records in the right table for a row from the left table, the fields from the right table in the result set will be NULL.

For example, if there is a users table and an orders table, and we do:

SELECT users.id, orders.id
FROM users
LEFT JOIN orders ON users.id = orders.user_id;

For users without orders, the orders.id field will be NULL.

In Go, when scanning such results, you need to consider the possibility of NULL values, for example, by using types like sql.NullString, sql.NullInt64, etc., to correctly handle the absence of data from the right table.