Can anyone help me in combining the data in 1st set to the one in 2nd set. WID,LID are key columns in the set.
asked
how to combine two consecutive dates in different rows in a table
What do you want as the output?
A data set of 9 rows? If so use a union
A set of matching data from both tables? (3 rows) use a INNER JOIN
A set of matching data from one table, and any matching data from the second? (6 rows with nulls) use an OUTER JOIN
1st set of 6 records are from original table and script should combine records into bottom 3 records .
For each WID,LID if startdate of 2nd record is immediate date of previous enddate ,we need to merge those records into a single record
Please post in a picture in excel or something what you want the output to look like
21 People are following this question.
