If you wanted to do this using a SELECT you would do a LEFT JOIN or
equivalent action. Glancing over the DELETE syntax in the documentation it
does not look like DELETE supports any such mechanism. I dont think it is
possible to involve more than one table in a DELETE query.
ryan
> I have two ta
Simon Grabowski wrote:
> Hi,
>
> I have two tables: table1 and table2.
> Both tables share the same 'account_id'
> column. In table1 there is a column
> 'active' which is always either 'y' (account
> active) or 'n' (account inactive).
>
> Now here is what I want to do...
>
> I want to delete all
Hi,
I have two tables: table1 and table2.
Both tables share the same 'account_id'
column. In table1 there is a column
'active' which is always either 'y' (account
active) or 'n' (account inactive).
Now here is what I want to do...
I want to delete all entries from table2
with account_id matchin