Different results with SELECT SQL and DELETE SQL. 
Author Message
 Different results with SELECT SQL and DELETE SQL.

To all VFP gurus.

I have 2 sql statements which produce different results with the same filter
clause:
The delete statement deletes more records than the select returned.

select * from table_a ;
 where keyfield_a in (select keyfield_a from table_b) and ;
 keyfield_a not in (select keyfield_a from table_c)

delete from table_a ;
 where keyfield_a in (select keyfield_a from table_b) and ;
 keyfield_a not in (select keyfield_a from table_c)

Has anyone seen this?

TIA

Regards
JL



Sat, 15 Jan 2005 00:35:50 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Select - SQL without a result set

2. what settings can effect results of SELECT SQL

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

4. SELECT SQL return wrong result

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

6. Select - SQL gives inconsistent results

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

8. IIF results in a Select - SQL statement

9. Slow SQL Select results - help?

10. Problem of putting the result of SQL Select to an existing table

11. How to process SELECT SQL results ?

12. SQL - result result order

 

 
Powered by phpBB® Forum Software