Thanks for all your help and patience!

This works- this is great. Thank you so much... Now I also see that there was a letter q after that nested query too which i thought was some kind...

ah, you have to name the nested query. it does work. this has to be a new feature. it's been a few years since i've used ms sql. in oracle...

i'm just testing the nested query

select * from (select * from anytable)

if you are going to test it- use any table. run it on dual

as far as compatability goes- it's...

quoted from this article

http://www.aspfree.com/c/a/MS-SQL-Server/Subqueries-and-Query-Expressions/6/

"Conceptually, SQL should let you substitute the view definition right into the query, like this:

  SELECT MFR,  PRODUCT,  SUM (QTY)

 ...

you can however use a nested subquery in a where statement on sql server but not the from. i would love to be proven wrong.

not on my server. what version do you use? i'm talking about microsoft sql server. i'm on 7. are you really able to do this? i can't get around the...

except that selecting from select statements is not legal in sql server. unless i've been wrong all these years and they've changed something.

select * from (select * from tblCompSR_cross)...

Hi- I'll explain further...

I have 3 tables- all 3 tables contain information about processes which are identified by prid- that's the id of the process. The prid is unique...

oh- just realized i never specified ms sql server. sorry.

Hmm, I've never been able to select from a query in ms sql server- that's only one of the many errors this gives me