Helllo Supratim, does each pub_code appear maximum three times in the table?
2008/11/10, Supratim Bandyopadhyaya <[EMAIL PROTECTED]>: > > 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 > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/