two records per row from query
От | John |
---|---|
Тема | two records per row from query |
Дата | |
Msg-id | 200908051651.13235.jfabiani@yolo.com обсуждение исходный текст |
Ответы |
Re: two records per row from query
Re: two records per row from query |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: