View Single Post
  #1 (permalink)  
Old November 14th, 2007, 06:11 PM
milindsaraswala milindsaraswala is offline
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to milindsaraswala Send a message via Yahoo to milindsaraswala
Default Removing duplicate Value Row

I have two tables both are having some data now what i want i want remove some duplicate data in column as for example

Table1 Table2
----------------------- ------------------------------------
Date | DocNumber | Qty Date | ExternNumber | Qty



Now i want remove rows where DocNumber and ExternNumber are same. It may be happen that DocNumber and ExternNumber having same value may be not come in same row.

Reply With Quote