
June 13th, 2000, 10:28 AM
|
|
Contributing User
|
|
Join Date: Mar 2000
Posts: 60
Time spent in forums: < 1 sec
Reputation Power: 14
|
|
|
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?
|