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" Subject: how to generate the follo Message-ID: 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 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