MySql query sum rows based on other column value -


hey have weird logic can 1 me write query. want sum prices regoption regoption have xncoupon (coupon , regoption share same entry_id). in exaple wanted amount 139.

|id         |trans_id|  entry_id    |type     | price ------------------------------------------------------  |43575855   |24419612|  26898343    |regoption|  139          |43575856   |24419612|  26898343    |xncoupon |  50  |43575857   |24419612|  26898346    |regoption|  139          |43575858   |24419612|  26898346    |tshirt   |  10

in second example wanted amount 278

|id         |trans_id|  entry_id    |type     | price ------------------------------------------------------  |43575855   |24419612|  26898343    |regoption|  139          |43575856   |24419612|  26898343    |xncoupon |  50  |43575857   |24419612|  26898346    |regoption|  139          |43575858   |24419612|  26898346    |xncoupon |  50

my try this

select sum(price) table type ='regoption' , (something) check regoption related xncoupon same entry_id?

can me logic, welcomed

select sum(price)  table  type = 'regoption'  , entry_id in (     select entry_id      table      type = 'xncoupon' )

-

Comments

Post a Comment

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

i have custom members system have made: yii2 members system . can refer full details, or install can work question. i have frontend , backend yii2 provides, few modifications separate sessions/cookies backend works admin model , pulls admin table. similar old traditional member systems. mainsite clone of frontend , it's role main website. when go www.site.com or site.com . here 3 apps , example domains: mainsite = www.site.com or site.com frontend = users.site.com backend = admin.site.com when user logs in ( users.site.com/site/login ) , go homepage ( mainsite @ www.site.com ) want know logged in , show username. how frontend operates default advanced app. from have far, login , head mainsite , reads an internal server error occurred. . doesn't yii error, server error? when in yii logs under runtime, mentions access control: 2017-04-14 13:38:25 [127.0.0.1][1][-][error][yii\web\httpexception:403] exception 'yii\web\forbiddenhttpexception'...
Read more

angular - password and confirm password field validation angular2 reactive forms -

i need check whether password , confirm password fields have same value using reactive form angular2. did see lot of answers on same here, angular 2 form validating repeat password , comparing fields in validator angular2 , none seemed work me.can please help."this" undefined in validate function :( . sharing code, this.addedituserform = this.builder.group({ firstname: ['', validators.required], lastname: ['', validators.required], title: ['', validators.required], email: ['', validators.required], password: ['', validators.required], confirmpass: ['', [validators.required, this.validatepasswordconfirmation]] }); validatepasswordconfirmation(group: formgroup): any{ let valid = true; // if (this.addedituserform.controls.password != this.addedituserform.controls.confirmpass) { // valid = false; // this.add...
Read more

javascript - Angular2 intelliJ config error.. Cannot find module '@angular/core' -

Image
i new angular2. following tutorial angular2 example . first simple tutorial called guess-the-number i used code described in github provided example https://github.com/chandermani/angular2byexample/tree/master/guessthenumber . it loads fine in browser. intellij setup i'm having issues. intellij returning following error.. seen in screenshot. cannot find module '@angular/core' my properties file follows systemjs.config.js system.config({ map : { 'app': 'app', 'rxjs': 'https://unpkg.com/rxjs@5.0.0-beta.12', '@angular/common': 'https://unpkg.com/@angular/common@2.0.0', '@angular/compiler': 'https://unpkg.com/@angular/compiler@2.0.0', '@angular/core': 'https://unpkg.com/@angular/core@2.0.0', '@angular/platform-browser': 'https://unpkg.com/@angular/platform-browser@2.0.0', '@angular/platform-browser-dynamic': 'https://unpkg.c...
Read more