> Home > Scripts > SQL

 

Example of an minus SQL statement:

 

This select is designed to show a set of names that exist in set 1 ( customer_address) and do not have a matching set in set 2 ( customer_service_location).

 

 

(

  SELECT NAME

   FROM CUSTOMER_ADDRESS

)

MINUS

(

  SELECT NAME

  FROM CUSTOMER_SERVICE_LOCATION

)

;