June 13th, 2000, 11:28 AM
I am having a difficult problem working with the parameters I have been given.
I have two tables, table1 and table2.
Table1 is a load data infile from external text file
Table2 is updated (only changed information) by Table1.
NOW, I need to delete a row from table2 where a specific field is empty in table1, before updating table2 with table1.
I know joins, i know delete, but I can't figure out how to get the two to play together.
June 20th, 2000, 02:18 AM
I may be wrong, but I would imagine that this would work much in the way you insert data data.
When we insert data from a form, we're inserting to muliple tables, mostly, and linking that data via a primary table.
I would guess my first attempt would be to perfom the delete from the minor table first, then the major table.
Low Cost Hosting and Web Development.