SQLTeam.com | Weblogs | Forums

How to get single record

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)?