hi friends..
I need an alternate query without using UNION for below query..
select DIST_NO from acquired_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'
union select DIST_NO from transfrd_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'