Brannon King <brannonking-/[EMAIL PROTECTED]> wrote:
Suppose I have two tables, A and B. A has two columns: score, location. B has two columns leftLocation, rightLocation. I need the maximum score located outside all entries in table B. B is a small table, say less than 100 entries.
select max(score) from A where not exists(select * from B where A.location between B.leftLocation and B.rightLocation)
Igor Tandetnik
