帮忙查一下 ,这段代码是怎么错了
use pubs
select title
from titles
having max(advance)>all
where advance>all
(
select max(advance)
from publishers inner join titles on
titles.pub_id=publishers.pub_id
where pub_name='algodata infosystems'
)
use pubs
select title
from titles
having max(advance)>all
where advance>all
(
select max(advance)
from publishers inner join titles on
titles.pub_id=publishers.pub_id
where pub_name='algodata infosystems'
)
select title,advance
from titles
where advance>
(
select max(advance)
from publishers inner join titles on
titles.pub_id=publishers.pub_id
where pub_name='algodata infosystems'
)?
advance〉all 什么概念阿