Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mutual DELETE
Message
 
 
To
26/09/2002 13:38:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00704839
Message ID:
00704851
Views:
18
How about:

delete from mytable where Num1 = ?nValue and Num1 in
(select Num2 from MyTable where Num1 = ?nValue)

>Hi,
> I would like to delete each time two mutual records in the process.
>for example :
>mytable.dbf
>
>num1 num2
>11111 22222
>33333 44444
>22222 11111
>55555 66666
>77777 88888
>99999 00000
>
>means the 1st record and 3rd record should be deleted from the table,
>
>11111 22222
>22222 11111
>
>Any help in coding will be appreciated.
>PP
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform