SQL Delete statement

[arrow483]

I'm still new to SQL. I found the following statement. I understand the WHERE clause, but what table is getting deleted? Only frl_per_bal, or both tables?


Delete frl_per_bal
FROM frl_per_bal B, frl_trx_delta_temp T
WHERE B.entity_Num = T.entity_num


Thanks!

 

[nigelrivett]

Delete frl_per_bal
will only delete from that table - data manipulation statements can only affect a single table apart from cascades, triggers and suchlike.

The rows that will be deleted are those returned from the join.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[arrow483]

Thanks. That's what I expected, but I have only seen it before with JOIN specified - not with a comma. Is JOIN assumed in this case?