SELECT Fld1 FROM SCHEMA1.TABLE1
SCHEMA1.TABLE1.Fld1= (SELECT Fld2 FROM Schema2.TABLE2)
The two tables belong to diff schemas.
Imagine the sub-query is retrieving 20 records of Fld2 and passing them to Fld1. It gives an error which says that the query cannot be executed since the sub-query is returning multiple no. of records.
Can any one help me out.....