You can use UNION

>How do I do this in one command, so I get a combined table?
>The structures are identicle.
>
>

>cInvoiceId = PADR(cInvoiceId, 20)
>cStatName  = PADR(cStatName, 10)
>
>SELECT * ;
>  FROM Commits;
>  WHERE InvoiceId = cInvoiceId AND;
>        StatName = cStatName;				
UNION ALL ;
>SELECT * ;
>  FROM Commits_Hist;
>  WHERE InvoiceId = cInvoiceId AND;
>    StatName = cStatName;				
  INTO CURSOR TmpInv
>