What happens if you append directly from TableB without going through the cursor?

Alan

>I have the following code in a prg
>
>

SELECT TableA
>ZAP
>
>SELECT * FROM TableB INTO CURSOR C
>
>SELECT TableA
>APPEND FROM DBF('C')

>
>Cursor C contains the following
>ID VALUE
>------------
>1 Task 1
>2 Task 2
>3 Task 3
>4 (empty)
>
>After the append statement TableA contains the following
>ID VALUE
>------------
>1 Task 3
>2 Task 2
>3 Task 3
>4 (empty)
>
>Can anyone see my mistake?
>
>Thanks in advance.