G
Guest
I have 1 table. It has 5 columns of data. 1 column has ID numbers, and
another has Class Room numbers. I am only interested in only 4 of the ID
numbers.
One class room can have many IDs, and one ID may be in multiple class rooms.
This table has about 90,000 lines.
I need to divide up this table, or separate in some way so that at the end I
have the following:
I have only the class room numbers in which those 4 ID numbers fall into,
but I need all the data, including all the other ID numbers also in those
class room numbers.
Am i being clear?
another has Class Room numbers. I am only interested in only 4 of the ID
numbers.
One class room can have many IDs, and one ID may be in multiple class rooms.
This table has about 90,000 lines.
I need to divide up this table, or separate in some way so that at the end I
have the following:
I have only the class room numbers in which those 4 ID numbers fall into,
but I need all the data, including all the other ID numbers also in those
class room numbers.
Am i being clear?