litknd/tsqlbeginners

A TSQL Course for Beginners

tsqlbeginners's Issues

Q2 has a spelling mistake in the name of the field to select

In Question 2 on 5_Joins_Homework.SQL file there is a spelling mistake.

When you say StateProvideName I think you mean to say StateProvinceName

In the explanation video you have it spelt right.

/*
Q2
Return two columns:
StateProvinceName, CountryName
Return rows for all Countries, with a related StateProvideName IF it exists.
The query should return 242 rows.
Write two versions of the query, one with a LEFT OUTER JOIN,
and one with a RIGHT OUTER JOIN
*/