Sub-query statement

The purpose of a sub-query join is to include record from the first set that only match records in the second data set.

SELECT NAME,

ADDRESS,

CITY,

STATE,

ZIP

FROM CUSTOMER_ACCOUNT

WHERE NAME IN

(

SELECT NAME

FROM CUSTOMER_ACCOUNT

WHERE STATE = 'TX'

)

;