SELECT QUERY
From: SELECT QUERY HELP (anonymous_at_discussions.microsoft.com)
Date: 08/30/04
- Next message: nique: "Re: PASS THROUGH QUERY WITH ORACLE BACK END"
- Previous message: Gerald Stanley: "Re: SQL help"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 13:26:00 -0700
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
- Next message: nique: "Re: PASS THROUGH QUERY WITH ORACLE BACK END"
- Previous message: Gerald Stanley: "Re: SQL help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
