S
subs
ocity ost ozip dcity dstate dzip consignee shipdate
a b c d e f cat 1/2/2008
a b c d
e f cat 1/2/2008
f g o l
m n cat1 2/4/2008
f1 g1 o1 l
m n cat1 2/4/2008
f1 g1 o1 l
m n cat1 2/4/2008
I want to delete the first two records in this table since they donot
have any other record with SAME dcity,dstate,dzip ,consignee ,shipdate
but DIFFERENT ocity,ost and zip. On the other hand , the last two
records have another matching record(the third one) which have SAME
dcity,dstate,dzip ,consignee ,shipdate but DIFFERENT ocity,ost and
zip. IS THERE ANY SQL QUERY or Delete Query with a condition.PLS HELP
a b c d e f cat 1/2/2008
a b c d
e f cat 1/2/2008
f g o l
m n cat1 2/4/2008
f1 g1 o1 l
m n cat1 2/4/2008
f1 g1 o1 l
m n cat1 2/4/2008
I want to delete the first two records in this table since they donot
have any other record with SAME dcity,dstate,dzip ,consignee ,shipdate
but DIFFERENT ocity,ost and zip. On the other hand , the last two
records have another matching record(the third one) which have SAME
dcity,dstate,dzip ,consignee ,shipdate but DIFFERENT ocity,ost and
zip. IS THERE ANY SQL QUERY or Delete Query with a condition.PLS HELP