Hello all thank you for taking the time to read my question.

I am new to writing SQL statements actually I've taken "Querying MS SQL
server 2K with Transact- SQL".. so basically SQL 101.

I need some guidance on how to query a query.

I have a desktop database which contains information on all users, software
on the desktop, location based on IP address, and much much more. What I
need to do is find all users that have T1.MS Project and T1.MS Project
Version that are on T2.subnet#1 OR T2.subnet#2 OR T2.subnet#3.

I hope I've explained what I need assistance with enough for one of you to
help me out.

Thank you in advance.

- Michael

Someone will be able to help you, if you could provide your table
structures, some sample data and desired output.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
Hello all thank you for taking the time to read my question.

I am new to writing SQL statements actually I've taken "Querying MS SQL
server 2K with Transact- SQL".. so basically SQL 101.

I need some guidance on how to query a query.

I have a desktop database which contains information on all users, software
on the desktop, location based on IP address, and much much more. What I
need to do is find all users that have T1.MS Project and T1.MS Project
Version that are on T2.subnet#1 OR T2.subnet#2 OR T2.subnet#3.

I hope I've explained what I need assistance with enough for one of you to
help me out.

Thank you in advance.

- Michael