SQL puzzle

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 2 years 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.98) 81 reviews

United States
Towson 09:03 AM

219 Jobs Posted
42% Hire Rate, 8 Open Jobs

Over $10,000 Total Spent
109 Hires, 8 Active

$15.67/hr Avg Hourly Rate Paid
588 Hours

Member Since Jul 25, 2010