Is it possible to use to Select in same Sql Statement

[Nader]

I'm using Vb2005 and Db MS access
Is it possible to use tow Select in same sql Statement
like this example:

"Select....Select......."

If it possible, may you give me example please.

 

[vks.gautam1]

we can use Subqueries.

 

[Nader]

Thank you for help!

 

[vks.gautam1]

Example--

Select
t1.*
From
table1 as t1
Where
t1.columnName>(
Select
t2.columnname
From
table2 as t2
Where
t2.columnname<1000)

 

[Nader]

Thank you again for help!.