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.
>
> selec
Brannon King
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
2 matches
Mail list logo
