Home » SQL & PL/SQL » SQL & PL/SQL » delete
delete [message #253196] Mon, 23 July 2007 01:52 Go to next message
steffeli
Messages: 112
Registered: July 2006
Senior Member
Hello

I have two table TAB1 and TAB2 with the fields P1 and P2. How can I delete all records in TAB1 which are in TAB2 (same combination of P1 and P2)?

Thanks
Stefan

[Updated on: Mon, 23 July 2007 02:02]

Report message to a moderator

Re: delete [message #253203 is a reply to message #253196] Mon, 23 July 2007 02:32 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this is a basic statement, please post what you alredy tried and why this did not work.

Regards
Michel
Previous Topic: problem is getting result .. I am a lazy SOB!
Next Topic: Alter View........
Goto Forum:
  


Current Time: Sat Dec 10 16:33:19 CST 2016

Total time taken to generate the page: 0.09892 seconds