I have a number of tables that all belong to a single database. One of the tables, ROUTNO, is considered the "header" table which has ROUT_NO as an index. The other tables also have ROUT_NO as an index.
What I want to accomplish is to create a command that will delete records from the "minor" tables that has ROUT_NO that DOES NOT exist any longer in the header table. Is this possible and how?
Thanks for any advice anyone can give.
Rick
What I want to accomplish is to create a command that will delete records from the "minor" tables that has ROUT_NO that DOES NOT exist any longer in the header table. Is this possible and how?
Thanks for any advice anyone can give.
Rick