DELETE Statment Problem in VB6

[elbatz]

Does Anyone know how to code this example in DELETE STATEMENT?

Table1 , Table2
field1 , field2 , field1 field2
22 , aaaa , 22 , aaaa
22 , bbbb , 22 , cccc
22 , cccc , 22 , bbbb
33 , ssss , 33 , ssss
33 , xxxx , 33 , xxxx

Suppose I'm going to delete all records from Table2 using Table1.Field1 as reference.All 22 in Table2 must be deleted. How to code this one?

[QVeen72]

Hi,

Which field of table2 is linked with table1's which field....?

Regards
Veena

[elbatz]

Hi,

Which field of table2 is linked with table1's which field....?

Regards
Veena

table2.field1 linked to table1.field1

thanks

[debasisdas]

try this

delete from table where field1=the value form field1 of table1

[QVeen72]

Try this :

Delete From Table2 Where Field1='22'
 

Regards
Veena