Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #336

how to generate the follo

Show all headers | View raw

  To: comp.lang.java.databases
I am really really new to sql,please forgive my
ignorence.

here is my problem

I have this table named mis_outtrack

desc mis_outtrack;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| pub_code    | varchar(3)  | YES  |     | NULL    |       |
| status_flag | varchar(2)  | YES  |     | NULL    |       |
| user_id     | varchar(15) | YES  |     | NULL    |       |
| entry_date  | date        | YES  |     | NULL    |       |
| pub_date    | date        | YES  |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+

select * from mis_outtrack;
+----------+-------------+---------+------------+------------+
| pub_code | status_flag | user_id | entry_date | pub_date   |
+----------+-------------+---------+------------+------------+
| SND      | RE          | AMY     | 2008-11-01 | 2008-11-01 |
| SND      | AU          | AMY     | 2008-11-05 | 2008-11-01 |
| SND      | SE          | AMY     | 2008-11-10 | 2008-11-01 |
| MND      | RE          | AMY     | 2008-11-03 | 2008-11-02 |
| MND      | AU          | AMY     | 2008-11-15 | 2008-11-02 |
| MND      | SE          | AMY     | 2008-11-15 | 2008-11-02 |
+----------+-------------+---------+------------+------------+

here pub_code is short name for a particular news paper
useid is the user who is updating the records
pub_date is the date of publication of that news paper
and
entry_date is the date when the user is updating the inserting
the status of that publication

here RE means recieved
     AU means audited
     SE means send
   there can only be these three status flags


I have to write an sql to display this data in the following format
------------------------------------------------------------------------
pub_code  |entry_date    |entry_date    |entry_date    |pub_date
|
(for a    |(when         |(when         |(when         |(publication
|
particular|status was RE)|status was AU)|status was SE |date for
|
pub_code) |              |              |              |that news
paper|
------------------------------------------------------------------------
|  SND        2008-11-01    2008-11-05     2008-11-10    2008-11-01
|  MND        2008-11-03    2008-11-15     2008-11-15
2008-11-02
|
|


how can I do this in sql


 any help will be appriciated.

Thanks in advance

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

how to generate the follo "skywalker" <skywalker@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000

csiph-web