SQL Table Join Query

SELECT table1.field1, table2.field2
FROM table1
JOIN table2 ON table1.field1 = table2.field1;

• This query uses the JOIN keyword to link two tables based on a common field.
• It selects the field1 from table1 and field2 from table2.
• The ON clause specifies the condition for the join, stating that table1.field1 should be equal to table2.field1.
• The result will include the selected fields from both tables, where the common field values match.