Each SQL SELECT statement returns a table. You can use that table in a JOIN statement. To do that, you give it a name. This is called a derived table. In this video I use a derived table and a LEFT OUTER JOIN to get the information from the data.
On this page of the site you can watch the video online Using a Derived Table with a duration of hours minute second in good quality, which was uploaded by the user Linda DuHadway 24 June 2018, share the link with friends and acquaintances, this video has already been watched 4,267 times on youtube and it was liked by 52 viewers. Enjoy your viewing!