>Im a newbie to this. I want to append two tables. Both are similar in structure. Tabel A and Table B. I willbe appending A into B. Some of the records in Table A, in the first field "Invno" are also in TAble B. How do I do it so that it will only append with "invno" records that are not in B?
If the two tables have identical
invno fields:
SELECT * from table B ;
WHERE invno NOT IN (SELECT invno FROM table A) ;
INTO CURSOR Temp
SELECT table A && it's been opened above
APPEND FROM (DBF('Temp'))
USE IN Temp
USE IN table B
Note that this won't handle any structural differences for you; the cursor from the first SELECT will give the records from table B whose invno doesn't already exist in table A, so you could spin through it and do inserts into A.
