Can any one please help to solve this.
Screen1 and screen2 are my two results sets,from these two result i want to get only one record instead of two records.
How can write the update query for this scenario.
Not sure I understand exactly what you're trying to do.
One row per query (use inner join)?
Merge the two queries into one with one or two row(s)?