mysql - show all rows from left join -

-

i have query 

select if(viaturas.transportador null,        'sem transportador', viaturas.transportador) transportador,        sum(ifnull(retorno_euro,0))- sum(ifnull(devolucao_euro,0)) total_euro,        sum(ifnull(retorno_ddf,0))- sum(ifnull(devolucao_ddf,0)) total_ddf,        sum(ifnull(retorno_vadias_plast,0))- sum(ifnull(devolucao_vadias_plast,0)) total_plast transportes.transportation_order     left join transportes.viaturas on viaturas.viatura=transportation_order.viatura estado not in ('cancelado', 'eliminado')   , servico in ('distribuição', 'devolução', 're-entrega')   , data >= '2016-08-08' group lower(transportador);

but shows result matched rows. how can show "tranportador" rows when there no match between tables?

when left join, put right side table conditions in on clause true left join behavior. (when in where clause, you'll regular inner join result.)

select if(viaturas.transportador null,        'sem transportador', viaturas.transportador) transportador,        sum(ifnull(retorno_euro,0))- sum(ifnull(devolucao_euro,0)) total_euro,        sum(ifnull(retorno_ddf,0))- sum(ifnull(devolucao_ddf,0)) total_ddf,        sum(ifnull(retorno_vadias_plast,0))- sum(ifnull(devolucao_vadias_plast,0)) total_plast transportes.transportation_order     left join transportes.viaturas on viaturas.viatura=transportation_order.viatura   , estado not in ('cancelado', 'eliminado')   , servico in ('distribuição', 'devolução', 're-entrega')   , data >= '2016-08-08' group lower(transportador);

Comments

Post a Comment

Popular posts from this blog

PHP while loop dynamic rowspan -

-
Image
consider table example using these table wanted print table these adding rowspan item id 1002. here php code $temp_val = ''; $counter = 1; $sql_sel = mysqli_query($con,"select * item_table"); while($res_sel = mysqli_fetch_array($sql_sel)){ if($temp_val == $res_sel['item_id']){ $counter++; echo "<tr></tr>"; } else{ echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; } $temp_val = $res_sel['item_id']; } echo "</table>"; it's not correct, it's adding rowspan item id 1003 you should switch code inside else , if statement
Read more

timer - Java TimerTask cancel -

-
i have following problem. every 2 seconds programm go inside if statement. inside if statement want have timer give me message after 15 seconds. timer should run delay of 1 second. while i'm "waiting" timer, if statement executed 7 times. problem is, have 7 same timertask @ same time running. how can solve problem? if (response == true) { final timer timer = new timer(); final int keepalivetimeout = 15000; //15 seconds timer.schedule(new timertask() { @override public void run() { if (response) { response = false; log.i(tag, "********response******"); timeoutcounter = 0; } else if (timeoutcounter > keepalivetimeout) { log.i(tag, "********timer timeout******"); } log.i(tag, "********timer******"); timeoutcounter = timeoutcounter + 1000; } }, 0, 1000); } from java api : public void schedule(timertask task, long delay, ...
Read more

android - How to read a column value in parse.com without accessing an object or a pointer -

-
by using code, not able 'name' unless use objectid = xj34weo . suggest way, if not, @ least using pointer. //parse query initialization final parsequery<parseobject> query = parsequery.getquery("myusers"); //to check row has "number"="1234" query.whereequalto("number", "1234"); query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null) { try { //xj34we0 objectid query.get("xj34weo").get("name") + ""); } catch (parseexception pe) {} } } }); are trying employee object number? you have list<parseobject> , use it. query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null && employ...
Read more