Make Another Query Using the existing result set.
Posted on 2003-12-10
Table #1 looks like this: Table #2 looks like this:
Record # goodOrBad Record # User Name
1 good 1 moe
2 bad 2 larry
3 good 3 curly
4 good 4 shemp
So I could issue a query 'give me the record # of all the "good" records'. The results would be
1, 3, and 4.
I want to issue a second query using the results of the first query. I want the user names with a "good" record. So the result in this case would be: moe, curly, shemp.
What's the query I need for this? (It could be a single query or two sequential queries)