Session 11

* In this session we talked a little more about SQL - Structured Query Language.
* An SQL statement always starts with either SELECT, DELETE, UPDATE or INSERT.
* We can also add a FILTER to an SQL statement, for example:
"SELECT * FROM ApprovedTravelRequests WHERE FirstName = 'Janet'"
SELECT * = SELECT ALL
ApprovedTravelRequests = Name of Table
WHERE = Filter
FirstName = Field
* The above will return all the details for that person.
* We can also specify which details should be returned:
"SELECT Location FROM ApprovedTravelRequests WHERE FirstName = 'Janet'"
* The above will only return the details from the Location field.
* To return the details from more than one field we use a comma between the field names:
"SELECT Location, TripDates FROM ApprovedTravelRequests WHERE FirstName = 'Janet'"