What techniques are used to retrieve data from more than one table in a single SQL statement?

COBOL SQL Interview Questions

(Continued from previous question...)

What techniques are used to retrieve data from more than one table in a single SQL statement?

Joins, Unions and nested selects are used to retrieve data.

(Continued on next question...)

Other Interview Questions

• What are the wildcard characters ?
• What are some SQL aggregates and other built-in functions?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is a subselect? It is different from a nested select ?
• How do you eliminate duplicate values in SELECT?
• What is a foreign key?
• When do you use a LINK statement ?
• What does the term "grant privileges" mean?
• What happens when you say OPEN CURSOR?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• More...