GeekInterview
  Menu  
 Search 
  • Showing 1 - 3 of 3 Ans
  • ajith007

    Answered On : Dec 6th, 2007

  • Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.

  • Answer Question
  • Click here to Login / Register your free account

    Image Verification :

Copyright © 2024 GeekInterview.com | All Rights Reserved