Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
join 2 tables (transform/pivot)
This is not a very flexible solution but will do the trick. This works when the domain of the column Job is a set of known values at the time of writing the query. SELECT lid, lot, date, max(joba) as joba, max(jobb) as jobb, max(jobc) as jobc ...
