Select Queries

• Used for fetching information from an SQL database.
• 'Outputs' the data once successfully selected
• Allows selection from multiple tables but not multiple databases.

The Basic Construct

  SELECT `data` FROM `TABLE`
  WHERE `Condtion`
  ORDER BY `TABLE` ASC / DESC ;