subqueries?

From: Richard Price <explore65_at_yahooo.com>
Date: Wed, 12 Jan 2000 11:48:18 -0700
Message-ID: <204f4.53$kB3.3225@news.uswest.net>

I have two SELECT statements built that each produce nice 2 column result sets. ( they are separate because they perform GROUP BY results differently) . How can I combine them with SQL? They each have an ID field in common. I'd like to have a resulting table with the common ID and the two attributes from each result set.

It doesn't seem possible to build an over all SELECT statement that has a FROM clause that uses another SELECT statement as a target.

Any ideas would be wonderful to hear. Also, is there another news group that would be more appropriate for this?

Thanks!
Richard Received on Wed Jan 12 2000 - 12:48:18 CST