Problem of putting the result of SQL Select to an existing table 
Author Message
 Problem of putting the result of SQL Select to an existing table

I was trying to use SQL Select to do a query and put the result to an
existing table, but it complains that the table is already in the database.

Select * From Customer;
        Where LastName Like "A%"
        Into Table Results

The documetation says that it can overwrite an existing table.
Thanks.

Lz



Sat, 19 Feb 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. SELECT - SQL result set dependant on whether table is indexed

2. SQL SELECT into existing table?

3. Different results with SELECT SQL and DELETE SQL.

4. Writing query results to an existing table

5. Select - SQL without a result set

6. what settings can effect results of SELECT SQL

7. SELECT SQL return wrong result

8. FP 2.5 erratic Select SQL results when using date fields

9. Select - SQL gives inconsistent results

10. results: Filtering no-match record/field (SELECT-SQL)

11. IIF results in a Select - SQL statement

12. Slow SQL Select results - help?

 

 
Powered by phpBB® Forum Software