Now that we have inserted data into the
students_courses tables, let us look at the different mechanisms of retrieving data, we will be using the
SELECT command to retrieve the data. The
SELECT statement would expect two things as a minimum, the first would be what to retrieve and the second would be where to retrieve it. The simplest
SELECT command would be to retrieve all the student records from the students table:
In this query, we are using
* to retrieve the data for all the columns from the students table, this is not a preferred method of retrieving data. The preferred method for data retrieval is by ...