怎样写这个查询

[win1357]

两个表，要求查询表1中小于表2中某个字段值最大值
比如：通过查询表2 select column1 from tab1 where column2='111'
再查询表1 select max(col1<column1) from tab1
请教各位。

[aierong]

create table ai(i int,ii int)
insert into ai select 1,2
insert into ai select 2,2
insert into ai select 3,2

create table aii(i int,ii int)
insert into aii select 1,2
insert into aii select 2,2
insert into aii select 3,2

select max(a.i)
from ai as a join aii as b
on a.i<b.ii

[welyngj]

select top 1 col1 from tabl1 where col1<(select column1 from tab2 where column2='111') order by col1 desc

[伍子V5]

select max(a.col1) from table1 a
inner join table2 b
on a.col1<b.column1 and b.column2='111'

[txlicenhe]

Select max(col1) where column1 < (Select column1 from tab1 where column2 = '111') from tab1

[txlicenhe]

sorry:
Select max(col1) from tab1 where column1 < (Select column1 from tab1 where column2 = '111')

[yujohny]

select max(col1) from tab2
where col1< (select column1 from tab1 where column2='111')