DELETE using JOIN, is that possible in Vertica?

[jagadeesh]

Can we DELETE records based on JOIN.

that is delete records which are common between the tables.

Ex:

Delete from table_A join table_b
on a.col1=b.col1;

i am getting an error 4856: Syntax error at or near "join"

[JimKnicely]

Hi!

You must have been using MySQL where that syntax is ok

This DELETE statement will do the same thing in Vertica:

Code: Select all

DELETE FROM table_A 
 WHERE EXISTS (SELECT NULL
                 FROM table_b 
                WHERE table_b.col1 = table_A.col1);

Please make sure to test it!

[jagadeesh]

Oh ya... co-related...

Thanks... this works...