[SQL] SQL advanced sub select query

http://stackoverflow.com/questions/10090993/sql-advanced-sub-select-query

Select * from table1 where pkid in (select fkid from table2 where clause...)