SQL puzzle

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 1 year ago

Fixed Price

Delivery by March 19, 2014

$5.00

Budget

Details

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

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

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


About the Client

(4.99) 47 reviews

United States
Towson 11:32 PM

144 Jobs Posted
41% Hire Rate, 2 Open Jobs

$8,960 Total Spent
63 Hires, 4 Active

$18.20/hr Avg Hourly Rate Paid
413 Hours

Member Since Jul 25, 2010