On Nov 10, 10:58 am, skywalker <[EMAIL PROTECTED]> wrote:
> 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 |
> +-------------+-------------+------+-----+---------+-------+
> | 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
So why is this MySQL question posted in an Oracle newsgroup? A MySQL
solution will not be the same as an Oracle solution.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
