Select query help!

[Select query help!]

Hi people,

Pls help to select the following data.
Tha table has subnet, address, serail# and model columns.
I need to select the data where various addresses belong
to the same subnet. I also need to include serial and
model fields.

Thanks a million,

Serg

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not quite sure what you want, but, try this:

SELECT subnet, address, [serial#], model
FROM table_name
ORDER BY subnet, address

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0D6YechKqOuFEgEQIk8wCgup1UgwiYbuax3MU9/JpusDCLX5wAnRDD
CVV3JFK65zZWTAAPnp68ye0l
=n0qx
-----END PGP SIGNATURE-----

 

[Guest]

That is not quite what I need.
See, a network subnet could be on the same address.
Sometimes, various addresses share the same subnet. I
would like to see the report where various addresses share
the same subnet, inluding serial and model fields.

Thank you,

-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not quite sure what you want, but, try this:

SELECT subnet, address, [serial#], model
FROM table_name
ORDER BY subnet, address

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0D6YechKqOuFEgEQIk8wCgup1UgwiYbuax3MU9/JpusDCLX5 wAnRDD
CVV3JFK65zZWTAAPnp68ye0l
=n0qx
-----END PGP SIGNATURE-----

Hi people,

Pls help to select the following data.
Tha table has subnet, address, serail# and model columns.
I need to select the data where various addresses belong
to the same subnet. I also need to include serial and
model fields.

.