Yesterday we covered how to import data from an external file into SQL Server (white paper).

We also covered how to retrieve (SELECT) data from one or multiple tables (JOIN).

SELECT table1.field1,
  table1.field2,
  table2.field1,
  table2.field2 ...
FROM table1
INNER/LEFT/RIGHT JOIN table2
  ON table1.common_field1 = table2.common_field1
    AND table1.common_field2 = table2.common_field2
INNER/LEFT/RIGHT JOIN table3
  ON table1.common_field1 = table3.common_field1
    AND table1.common_field2 = table3.common_field2 ...

Download the class notes for day 2.

Remember that next Monday the 4th is Labor Day and BMCC will be closed. Enjoy the holiday and we will meet back on Wednesday the 6th.

If you have any questions, do not hesitate to contact me via email or https://introtosql.slack.com/.