SQL puzzle

Closed - This job posting has been filled and work has been completed.

Job Description

table a {
akey char(40)
table b {
akey char(40),
bkey int(11),
bType char(1)

a and b are joined with akey and bType are 'A','B','C', and 'D' and it is 1:M relationship
I want to select a.* where b.bType == 'C' only,
That is, I want records in a that exclusively have associated bType 'C' only weeding out the records in a with associated ('A','B','D') in tbl b

no that will not work because this is 1:M relationship and I want exclusive set

a1->bType='C' and a1->bType='A'
a3->bType='C' and a3.bType='D'
I want only a2 from above

Other open jobs by this client