S
SELECT QUERY HELP
Hi people,
Post my question again.
Pls help to select the following data.
The table has subnet, address, serail# and model
columns.
I need to select the data where various addresses belong
to the same subnet. See, a network subnet could be on
the same address. Sometimes, various addresses share the
samesubnet. I would like to see the report where various
addresses share the same subnet, inluding serial and
model fields.
The concern is to show a subnet where address is not the
same. I would say that the query has to return this:
subnet 1 address 1 serial 1 model 1
subnet 1 address 1 serial 2 model 1
subnet 1 address 2 serial 3 model 1
subnet 1 address 4 serial 4 model 1
from the table that contains this:
subnet 1 address 1 serial 1 model 1
subnet 1 address 1 serial 2 model 1
subnet 1 address 2 serial 3 model 1
subnet 1 address 4 serial 4 model 1
subnet 2 address 3 serial 6 model 1
subnet 2 address 3 serial 5 model 1
subnet 2 address 3 serial 7 model 1
Thanks a million,
Serg
Post my question again.
Pls help to select the following data.
The table has subnet, address, serail# and model
columns.
I need to select the data where various addresses belong
to the same subnet. See, a network subnet could be on
the same address. Sometimes, various addresses share the
samesubnet. I would like to see the report where various
addresses share the same subnet, inluding serial and
model fields.
The concern is to show a subnet where address is not the
same. I would say that the query has to return this:
subnet 1 address 1 serial 1 model 1
subnet 1 address 1 serial 2 model 1
subnet 1 address 2 serial 3 model 1
subnet 1 address 4 serial 4 model 1
from the table that contains this:
subnet 1 address 1 serial 1 model 1
subnet 1 address 1 serial 2 model 1
subnet 1 address 2 serial 3 model 1
subnet 1 address 4 serial 4 model 1
subnet 2 address 3 serial 6 model 1
subnet 2 address 3 serial 5 model 1
subnet 2 address 3 serial 7 model 1
Thanks a million,
Serg