Select Statement inside a Select Statement Input Tools

latimo1

I need to use a Select Statement inside a Select Statement.

Select * from Table1

where Id in (Select * from Table2)

Is this possible?

This would eliminate the need to get all Records from Table2 and then Join with Table1 and speed up my workflows.

Thanks!  John!

jordanmount6

just replace the 2nd * with ID

Select * from Table1

where Id in (Select ID from Table2)