Show data from one field based off another?

[Guest]

How do you show only the fields you want based data in a different field?

I have the following query..

HLP_CODE ... STATE

TCCXX1.... WA
TCCXX1 .... WA
CTVON2 .... TX
TCX111 .... FL
CTVON2 .... OH

I would like the criteria to say... if the data in field A matches "CTVON2"
then show only the records in field B that matches that query. Both fields
are in one table.

How would i do this in a select query?

 

[Guest]

SELECT HLP_CODE, STATE
FROM YourTable
WHERE HLP_CODE = "CTVON2" ;