I have a table which has sub-tables. I'd like to lose the
sub-tables but keep any sub-table rows which are common to
the parent table...including their primary key which is also
common to the main table.
If I DROP the subtable, will I lose all its rows? Or only
the columns not common to the parent table?
How best should I do this?
TIA,
Gan Starling
Kalamazoo MI