I encountered this small problem
I have two tables A and B  with two columns 1 and 2 each, I would like
the first column of each table when match the first in the second table
is to subtract the second column

When I run the following statement in FoxPro (versions 6.0 and 8.0), it
creates a new table.  The new table cannot be opened using Excel and a
couple other DBF viewers.  If you view the DBF file in a text viewer, the
header looks corrupted.

I'm working on a project that inserts data from a VFP 9.0 remote view
into SQL Server using VFP's TABLEUPDATE().  I then need to obtain the
value assigned to the identity field for the inserted record.  I have
created my remote view with filters on a datetime field (used as a

I have created two SQL VIEWS in a database.  Is there any way to join the
two views together by a common field?  I have worked with tables before and
they let you drag one field from one table to another field on the other
table and it creates a join.

Select * from table1;
where exists(  select * from table2;
where alltrim(upper(table1.f1))==alltrim(upper(table2.f1))  )
It gives error message-something like 'Error corelating fields'

There are two tables with the same id (for example id_s). In the first table
(t1) id is a primary key. In the second(t2) it is a foreign key.
How can I take the minimum of the another field (t2.f1  date) in the second
table with correlating another field (t1.f10  character)  in ...

I'm stumped!  I cannot get a result set from a query
that uses a 'NOT IN' clause.  It works in ver 8 but
I get zero results in ver 9.
Example:

There are two read-write cursors with identical structures.
The first cursor has data,  another is empty.
Could you describe copying contents of one cursor to another using query or
something else ?