 So students, in this module, I will of course talk about getting data from multiple tables, which is this set of modules is all about. But in this module, I will give you a little bit of background about getting data from multiple tables. So once we have stored the data in a table, which is of course in a database, we need to retrieve the data from that table, which is in a database. So of course, there are many SQL commands, but one of the SQL command, which is probably the most frequently used SQL command is the select command. So I will talk about it very briefly, and I'll show you that why it is very important to understand the usage of the select command and how it is used. So let's look at the module coverage in the next slide. So I will talk about the basic select statement. And of course, when we say select, in the MySQL environment, usually you select the retrieved data from a table, right? But in MySQL, you can perform an operation without retrieving the data from a table. And because when you retrieve the data from a table, you use the from clause. So I'll give you a very simple example of what MySQL can support without the from clause. And then looking at writing the joins. Join is that I have this data, which I have briefly discussed in the prior module, the static table and the dynamic table. So how do we connect the multiple tables to get what we are looking for? And that connection, that connection is named as the join. And finally, I will give you the tables, which we'll be covering in the sum of the following modules, what those tables are and what is stored in those tables. So let's go into more details. So this is the basic select command. So we have this select with the selection list over here. And what do we want to select? Say, for example, we want to select the age, we want to select the salary, we want to select the name or whatever, okay, that is selection list and the table list. So we can have table one over here, we can have table two and so on. And this is the where clause. This is like a filter. This is like a filter, okay, which conditions rose to satisfy. And group by a clause grouping basically I will talk about for the aggregates and sorting sorting basically is ordering having and limit one record or two and so on or three or whatever. So this what constitutes a select command. So over here we have this example of the select command without the from this is without, without, okay, without the from clause. So I am looking at a certain expression, right? So there is no from clause over here. There is no table, no table to select, to select from, okay? So we are just looking at an expression. So that expression gets evaluated. So that is the benefit of the SQL supported by MySQL, okay? And then writing the joints, joints, getting the data from multiple tables, retrieving data from multiple tables, often joining tables is the solution. So the, the, because of the relational models, because of the codes rules, because of these rules, we have this normalization and the data is split across multiple tables. So often the, the answer to your problem is that from which tables you need to get the data, you need to join them, you need to connect them. Usually this is the solution. Well, if that is the solution, what's the problem? The problem is the experience. One needs to have experience of performing the joints, of looking at different tables, right? And then getting what we are looking for. There's a very interesting quotation about the experience, is that experience comes from failures. And when you have experience, you don't fail. I think you understand. So now this approach is, is using, selecting from which tables that can be applied to variety of problems, many, many problems. But the thing is you need to have the experience that which tables to connect and how to get, and what data to get from those tables, okay? And finally the tables which we'll be looking in the set of modules. We have this table one over here. We have table two over here. This I one is integer. This is integer, integer data type, okay? And over here, this is the character data type. Character or string data type, okay? So we will be looking at this table and these two tables, T1 and T2, in the subsequent examples, the subsequent modules. So that's all I have for this module for you.