I have two tables, one contains a large list of IDs and Info regarding those ids.
I have a second table Graph
which just has two columns, each column contains the aforementioned id numbers, multiple times. I want to trim
the size of my Info
table by selecting only those ids that appear in my graph and creating a new smaller Info table. Is there a simple way of doing this?
CREATE TABLE FROM SELECT?
Thanks!
See Question&Answers more detail:os