Contoh Subquery di Sql Server 2008

--Subquery

select top 10 field1,field2
(Select field from table2
where field=table1.field
) alias
from table1