00:01
All right, so suppose that we have some kind of a database, and maybe we have a table that lists the professors.
00:14
So you might have a professor id, you might have a name, and then some other data.
00:20
And then you might have a data table for courses.
00:29
Again, you probably have a course id, a course name.
00:34
Maybe you have a professor that teaches it.
00:42
Well, maybe you have, this is important, what department the course falls under, and probably you have the professors have department.
00:58
So we want to use a squeal query to find the professor names and all of the courses that they teach outside of their department.
01:09
So we probably want to do a join query where we join based on the the professor is going to be common to both of the tables.
01:31
So we can sort the data according to that common key in both...