title: How to order a pre-ordered table
body: <p>When i query the database with this "union select":</p>
  
  <pre><code>select stampata_sn,numero_conto,dest_stampa,portata,categoria,prog_inser,nodo,desc_art,prezzo_un,quantita from comanda where contiene_variante='1' and ntav_comanda='1' and posizione='CONTO' and stato_record='ATTIVO'   and numero_conto = '1' 
  union all
  select stampata_sn,numero_conto,dest_stampa,portata,categoria,prog_inser,nodo,desc_art,prezzo_un,sum(quantita) as quantita from comanda where (contiene_variante !='1' or contiene_variante is null) and length(nodo)=3 and ntav_comanda='1' and posizione='CONTO' and stato_record='ATTIVO'  and numero_conto = '1'  group by desc_art 
  union all
  select stampata_sn,numero_conto,dest_stampa,portata,categoria,prog_inser,nodo,desc_art,prezzo_un,quantita from comanda where length(nodo)=7 and ntav_comanda='1'  and posizione='CONTO' and stato_record='ATTIVO'  and numero_conto = '1'  order by nodo asc;
  </code></pre>
  
  <p>I extract this datas, in that order:</p>
  
  <pre><code>PROGRESSIVO NODO    PRODOTTO            QUANTITA
  0           000     SAN PELLEGRINO      1
  1           001     MINERALWASSER 0.2 l 1
  2           002     MINERALWASSER 0.4 l 1
  3           003     COCA COLA 0.2 l     3
  4           004     COCA COLA 0.4 l     1
  5           005     COLA LIGHT 0.2 l    5
  6           006     COLA LIGHT 0.4 l    3
  7           007     APFELSAFT 0.4 l     1
  12          007     012 +SCHWARZWALD    1
  13          007     013 -ERDBEEREN      1
  8           008     APFELSAFT 0.2 l     2
  10          010     SPRITE 0.4 l        1
  11          011     SPRITE 0.2 l        1
  </code></pre>
  
  <p>The order is correct because the variants are linked to the products, but I want to see them in alphabetical order, like this: </p>
  
  <pre><code>PROGRESSIVO NODO        PRODOTTO            QUANTITA
  11          008         APFELSAFT 0.2 I     2
  7           007         APFELSAFT 0.4 I     1
  8           007 012     + SCHWARZWALD       1
  10          007 013     - ERDBEEREN         1
  3           003         COCA COCA 0.2 I     3
  4           004         COCA COLA 0.4 I     1
  5           005         COLA LIGHT 0.2 l    5
  6           006         COLA LIGHT 0.4 l    3
  1           001         MINERALWASSER 0.2 l 1
  2           002         MINERALWASSER 0.4 l 1
  0           000         SAN PELLEGRINO      1
  12          011         SPRITE 0.2 l        1
  13          010         SPRITE 0.4 l        1
  </code></pre>
  
  <p>How could I do?</p>