S
Stone
First of all, sorry for my poor english. I have a query problem. I
want to delete som files from my table, but there is a condition and I
can not do the right thing. There are 3 fields (there are more, but
don't mind) who have the information needed. I put an exemple:
I have this files:
File 1
Field1 = 1
Field2= x
Field3= 500
File 2
Field1 = 25
Field2= o
Field3= 1
File 3
Field1 = 2
Field2= x
Field3= 501
File 4
Field1 = 3
Field2= o
Field3= 502
File 5
Field1 = 35
Field2= o
Field3= 2
I need make a query who deletes the 4th file, because its field1
doesn't have any field3 (in any file) with the same value, and its
field is = o
File 1 have a field1 = file 2 field3, so they must keep (file 1 and
file 3)
File 3 have a field1= file 5 field3, so they must keep too (file 3 and
file 5)
I hope somebody can help me. Thanks in advance.
want to delete som files from my table, but there is a condition and I
can not do the right thing. There are 3 fields (there are more, but
don't mind) who have the information needed. I put an exemple:
I have this files:
File 1
Field1 = 1
Field2= x
Field3= 500
File 2
Field1 = 25
Field2= o
Field3= 1
File 3
Field1 = 2
Field2= x
Field3= 501
File 4
Field1 = 3
Field2= o
Field3= 502
File 5
Field1 = 35
Field2= o
Field3= 2
I need make a query who deletes the 4th file, because its field1
doesn't have any field3 (in any file) with the same value, and its
field is = o
File 1 have a field1 = file 2 field3, so they must keep (file 1 and
file 3)
File 3 have a field1= file 5 field3, so they must keep too (file 3 and
file 5)
I hope somebody can help me. Thanks in advance.