Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

SQL SELECT challenge...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL SELECT challenge...

    SELECT CASE WHEN keyfld = '770' THEN '390' ELSE keyfld END AS keyfld

  • #2
    SQL SELECT challenge...

    My DB contains approx 500 recs, all uniquely numbered with a 3 char key field. I want to make a SELECT that produces a sorted (by key) subfile. The challenge is to have record '770's data be accumulated to record '390's data and the sum presented as if it was '390'. '770' shal not be displayed anymore. How can I accomplish this in a SQL-statement ?

    Comment

    Working...
    X