SAP CDS SET OPERATORS - Glossary

Get Example source ABAP code based on a different SAP table

set operator
Set operators merge the result sets of multiple queries into a single result set. In CDS view entities and AB_SQL , the following set operators are available:

EXCEPT returns all distinct rows of the first result set that are not part of the following result sets.

INTERSECT returns all distinct rows that are part of all result sets.

UNION merges the result sets of all queries.
Set operators in CDS view entities
Set operators in AB_SQL