helpd with JOIN, DELETE, etc...

Howdy all,

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.

Ideas?

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.


------------------
SnR Graphics,
Low Cost Hosting and Web Development.