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

how to generate the follo

Path	csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!border4.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From	"skywalker" <skywalker@THRWHITE.remove-dii-this>
Subject	how to generate the follo
Message-ID	<e1016b06-e37f-41bf-883a-c5ec3cca7856@t18g2000prt.googlegroups.com> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
Content-Type	text/plain; charset=IBM437
Content-Transfer-Encoding	8bit
X-Gateway	time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines	73
Date	Wed, 27 Apr 2011 15:23:08 GMT
NNTP-Posting-Host	96.60.20.240
X-Complaints-To	news@tds.net
X-Trace	newsreading01.news.tds.net 1303917788 96.60.20.240 (Wed, 27 Apr 2011 10:23:08 CDT)
NNTP-Posting-Date	Wed, 27 Apr 2011 10:23:08 CDT
Organization	TDS.net
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:336

Show key headers only | 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