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




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

About the Client

(4.99) 55 reviews

United States
Towson 03:01 PM

161 Jobs Posted
41% Hire Rate, 7 Open Jobs

$9,747 Total Spent
78 Hires, 11 Active

$16.48/hr Avg Hourly Rate Paid
492 Hours

Member Since Jul 25, 2010