how to write sqlite update operation in two tables?
- by sxingfeng
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!