Subject | delete from table... best way? |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2011-09-15T13:24:40Z |
[FB 2.5]
Hello there!
a have a very common situation... a table (T1) which is joined to T2...
I want to delete all records from T1 that has a null description in T2
this works fine:
delete from t1 where (select t2.descripcion from t2 where (t1.id_t2 =
t2.id)) is null
but I wander if there is a better (shorter?) way to do the same...
thanks!!
-s
[Non-text portions of this message have been removed]
Hello there!
a have a very common situation... a table (T1) which is joined to T2...
I want to delete all records from T1 that has a null description in T2
this works fine:
delete from t1 where (select t2.descripcion from t2 where (t1.id_t2 =
t2.id)) is null
but I wander if there is a better (shorter?) way to do the same...
thanks!!
-s
[Non-text portions of this message have been removed]