Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mutual DELETE
Message
 
 
To
26/09/2002 14:51:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00704839
Message ID:
00704899
Views:
16
Try
SELECT Num1 + Num2 FROM mytable ;
	WHERE Num1 + Num2 IN ;
		(select Num2+Num1 from mytable ) ;
UNION ;
SELECT Num1 + Num2 FROM mytable ;
	WHERE Num2 + Num1 IN ;
		(select Num1+Num2 from mytable ) ;
	INTO CURSOR crsList	

DELETE FROM mytable ;
	WHERE num1+num2 in ( ;
		SELECT Num1+Num2 FROM crsList)
> Do I need to input ?nValue each time to delete ? the fact I have thousand
>mutual records to delete in one single process .
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform