Solving a relational query: part 2
![Tuple Image from [www.youvan.com], Example 7 i...](http://commons.wikipedia.org/wiki/File:Pseudocolor_tuple.jpg "Tuple Image from [www.youvan.com], Example 7 i...")
Image via Wikipedia
With thanks to Professor Paul A. Rubin, I think this may be the way to solve this:
This joins LOT to a relation with one attribute (LOT_ID) made up from tuples where LOT_ID should only be returned where no bids have been made that are equal or greater than the reserve price.
Very difficult part question for an exam, though 
Related articles
- Solving a relational query: part 1 (cartesianproduct.wordpress.com)
3 comments