Link to home
Start Free TrialLog in
Avatar of Tpaul_10
Tpaul_10Flag for United States of America

asked on

Need a SQL query

Experts,

I need a SQL query and the details are attached.

Thanks for your help.
doc2.docx
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

looks like homework to me. how do you think you will learn something if you don't even try to do your own homework?
SOLUTION
Avatar of WaibelRD
WaibelRD
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Select QNumber from QNumbers where DiscountType in (A','B')
intersect
Select QNumber from QDetails where DiscountGiven is null;
Not quite, need to deal with P7 case.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tpaul_10

ASKER

Thanks awking00 and  WaibelRD. Appreicate your help guys and sorry, I should have posted the SQL i have tried.


emoreau : DON'T ASSUME ANYTHING AND IF YOU DON'T WANT TO RESPOND, JUST SHUT UP OR DON'T RESPOND.