hi there
this might be an extreme solution.. but i thought you could come up
with just one query instead of 20 temp tables.. if you dont mind to
write it :)
select id,
max(if(datetype='entered_date',date,'')) entered_date,
max(if(datetype='modified_date',date,'')) modified_date,
max(if(datetype='
Shawn -
Maybe terminology here...but I think of a "crosstab" query as one which
yields sums or averages or
some such tabulation.
What I need to do is just "pivot" from rows to columns.
The way I've come up with is this:
ORIGINAL TABLE:
columns = id date datetype
there are about 20 datetypes
