TABLE1
ID FilesKeep
1 passwords.txt
5 salary.txt
TABLE2
ID FilesAll Flag
2 salary.txt
5 budget.txt
6 passwords.txt
where the identifier is the filename, not the id. If
so, then
update table2 set flag=delete
where filesall not in (select fileskeep from table1)
will do the job.
P.S. you might want to rethink your database design.
=====
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
