how to write sqlite update operation in two tables?

Posted by sxingfeng on Stack Overflow See other posts from Stack Overflow or by sxingfeng
Published on 2010-06-18T03:13:25Z Indexed on 2010/06/18 3:33 UTC
Read the original article Hit count: 215

Filed under:
|
|
|

I am using SQLite,

TABLE A
(
 ID
 FileNAME
 FOLDERID
)

TABLE B
(
 FOLDERID
 FOLDERPATH
)

I want to write a sql statement to delete all files in A where its Folder is subfolder of C:\ABC\; How Can I make it in one sqlite statement, and is it the best way to do?

Many thanks!

© Stack Overflow or respective owner

Related posts about sql

Related posts about update