Ok, thanks. That did it.
>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
>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
