Member Avatar for kartisathis

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'
  • 2 Contributors
  • 3 Replies
  • 72 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

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

Member Avatar for kartisathis

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.