Delete SQL
-
delete from table1,table2 where uid='abc' the conditon ( where uid='abc') is same for both table. that uid field are present in both table. I got error that Comma(,) should not be there is there any other syntax that can work?
You can only delete from one table at a time. You'll need to write two statements. Many providers can handle multiple statements in the same batch.
DoEvents: Generating unexpected recursion since 1991
-
delete from table1,table2 where uid='abc' the conditon ( where uid='abc') is same for both table. that uid field are present in both table. I got error that Comma(,) should not be there is there any other syntax that can work?
You can only delete from one table at a time. If you want to delete from more than one at a time, using only one command, then try using a stored procedure that executes the individual table deletes in one call. ---modified If there is a relationship between table1 and table2 with uid, then you could always setup a cascading delete based on that field.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon