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.
Copyright © 2024 GeekInterview.com | All Rights Reserved
Copyright © 2024 GeekInterview.com | All Rights Reserved