How to use retrieval update function from relational data?

Use of Retrieval Update Function from Relational Data

Retrieving function description from relational data--

SELECT statement is used for SQL language retrieval. It can also be used to select data from multiple relations.

SELECT statement syntax--

SELECT [distinct] <target-list>

form <relation__ list>

[where <predicate>]

Distinct: Specifies that all attributes will be displayed by default. Distinct clause should be used to avoid displaying any duplicate records in the query.

Target-list: List all the attributes to be displayed from a table. Multiple attribute names are separated by commas.

Relation list: All the tables that will be evaluated i.e. all the tables from which the data will be selected must be mentioned in the <Relation list> part with the form clause.

Predicate : Predicate is to be specified with where clause. Here data can be relative from multiple tables by defining a relation attribute as Predicate.