A query-expression is one or more table-expressions. Multiple table expressions are linked by set operators. The following figure illustrates the relationship between table-expressions and ...

I could swear that I've seen discussions on this, but I can't seem to find them...<BR><BR>I've got a stored proc that I wrote in SQL server that builds it's data from two different databases (on that ...

Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.