Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by qbecerra

  1. qbecerra

    Help with SQL - I get column with 0 for each record

    No... PUNTOS_RESTANTES is not a field in my DB, this is a field in the query... "... SUM(FACTURACION.PUNTOS) - SUM(CANJE.TOTALPUNTOS) AS PUNTOS_RESTANTES, ..." I had to put PUNTOS_RESTANTES in group by clause because i get error if i do not do so... :( Note: I also replaced...
  2. qbecerra

    Help with SQL - I get column with 0 for each record

    GROUP BY 1,2 ? I get syntax error... Anyway, I'm getting same result if I change the order of "appearance" in the group by clause... any ideas ? thanks a lot 4 helping.. the SQL engine I use is www.nexusdb.com and it is compatible with ISO SQL standards, etc.
  3. qbecerra

    Help with SQL - I get column with 0 for each record

    Hi guys 1º lemme explain situation: there're clients who buy at a shop. there're promotions in shop (can be normal or special). one promotion says: "for each u$s 100 you buy, you get 1 point". client can exchange points by gifts. 2º Take a look at this image...
See more

Part and Inventory Search

Back
Top Bottom