It works like a champ. Thanks. > > 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
