RE: sql delete question

2003-01-10 Thread Veysel Harun Sahin
Hello Adolfo, Yes I have tried it too but it did not work. Anyway i have done it programatically in my app. Thanks. Adolfo Bello [EMAIL PROTECTED] wrote: I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id

Re: sql delete question

2003-01-08 Thread Paul DuBois
At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote: Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each

Re: sql delete question - solved

2003-01-08 Thread Veysel Harun Sahin
Hello Paul, I have tried the code you have written, before posting to list and it did not work. When I have seen the sentence This requires that you have MySQL 4.x at your mail I realized the problem. I am using mySQL 3.23.49. :( Thanks for your help. Paul DuBois [EMAIL PROTECTED] wrote: At

RE: sql delete question

2003-01-08 Thread Adolfo Bello
I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the table1id column. I need to