Matches A Value Returned From A Sub Query For Instance On Another Table


"WHERE MyColumnName IN (SELECT SomeColumnNameToReturn FROM tblSomeTableName WHERE SomeColumnName=2)"