Use JOIN in SQL statements

[florian]

instead of WHERE chaining.

codeium.com:

Yes, it would be more reasonable to use JOIN statements in the
query instead of implicit joins (listing tables separated by
commas in the FROM clause). Here is the equivalent query using
JOIN syntax:

SELECT variants.format, mapping.variant_id 
FROM steps
JOIN mapping ON steps.content_id = mapping.content_id
JOIN variants ON mapping.variant_id = variants.identifier
WHERE steps.identifier = "id_xyz";

In this revised query:

• The JOIN keyword is used to explicitly define the relationships between the tables.
• Each table is joined based on the specified conditions (steps.content_id = mapping.content_id and mapping.variant_id = variants.identifier).
• The WHERE clause filters the results based on the condition steps.identifier = "id_xyz".