Selecting those rows that satisfy a condition specified for a particular column is called a retrieval. You can also join and search two or more tables based on the values of a specific column and obtain a single set of retrieval results.
This section describes retrieval from one or more tables.