View previous topic :: View next topic
|
Author |
Message |
Huzefa
New User
Joined: 05 Dec 2006 Posts: 83 Location: Bangalore
|
|
|
|
Hi,
Is there a way we can delete from 1 table joining 2 tables.
I know to delete based on joining 1 table as below
Code: |
DELETE TABLE1
FROM TABLE1 A
JOIN TABLE 2 B
ON A.COLUMN1 = B.COLUMN1
AND A.COLUMN2 = B.COLUMN2 |
Now if I want to delete from TABLE1 joining TABLE2 and TABLE3 how do I achieve.
Thanks in advance |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Needs clarification.
Show some "starting" rows from the tables and what should remain after your process is executed. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Huzefa,
You cannot do joins in DELETE statement in DB2.
Try this,
Code: |
delete from table1 a
where exists
(
select 1 from table2 b
where a.column1 = b.column1 and a.column2 = b.column2
)
; |
Thanks,
Sushanth |
|
Back to top |
|
|
|