Alternate for union two tables (urgent)..

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'

kartisathis

Newbie Poster

22 posts since Jun 2011

Reputation Points: 10

Solved Threads: 0

3 Months Ago

Without a UNION the results will be different. You could try a JOIN on FOLIO_NO.

pritaeas

Posting Expert

Moderator

5,484 posts since Jul 2006

Reputation Points: 653

Solved Threads: 875

3 Months Ago

ya i tried that too but the performance kills when compared to UNION

kartisathis

Newbie Poster

22 posts since Jun 2011

Reputation Points: 10

Solved Threads: 0

3 Months Ago

So what is it you're after then ?

pritaeas

Posting Expert

Moderator

5,484 posts since Jul 2006

Reputation Points: 653

Solved Threads: 875

This article has been dead for over three months

You

Home | About Us | Contact Us | Terms of Service | Advertising Opportunities

RSS Feed