mySQL 4.0 seems to have support for statements like this:
delete from tableA, tableB WHERE
tableA.B_ID = tableB.ID AND
tableB.Name = 'string I know';
but I misplaced some links to some very good tutorials on this. I can't seem to get that query to work, or this one:
UPDATE tableA, tableB SET
tableB.comment = 'something'
WHERE
tableA.B_ID = tableB.ID AND
tableA.FieldIKnow = 'string I know';
I could use this type of query.
Also is it POSSIBLE to delete child records ONLY on a join between two tables, where I joined the other table simply because of the data in a certain field in the other table which I know, WITHOUT deleting that record in the other table?
Many thanks,
Sam Fullman
