mytable
pkid
class_date.
sessionid
select * from mytable
1 2009/01/01 2101
2 2009/01/02 2101
I would like an SQL that would produce
newtable
pkid,
class_date1,
class_date2,
sessionid1,
sessionid2
Select * from newtable
1 2009/01/01 2009/01/02 2101 2101
I have a list of classes that is perfect for our needs. However, I need to
create the second table (from a query) to feed to a report writer so it can
write out a single line of text for two records.
Like:
Your class dates are as follows
Date Date
01/01/2009 01/02/2009
01/08/2009 01/10/2009
03/31/2009 04/05/2009
and will continue until the all the classes are printed.
The problem of course is the table has a row per class and the report writer
needs two class dates per row.
I have no idea how to do this using SQL.
Thanks in advance,
Johnf