swjtx99
asked on
Select to distinguish a value?
I want to one line that is something like ths:
Model Received_date Shipped_Date
Ford 12 Jan 10 15 Jan 10
The problem is that both dates are "events" in the same table so I get
Model Event_TYPE Event_Date
Ford Received 12 Jan 10
Ford Shipped 15 Jan 10
Is there a way to select
Event_TYPE (Received)
Event_Date (Received)
then select
Event_type (Shipped)
Event_Date (Shipped)
Does this make sense?
Model Received_date Shipped_Date
Ford 12 Jan 10 15 Jan 10
The problem is that both dates are "events" in the same table so I get
Model Event_TYPE Event_Date
Ford Received 12 Jan 10
Ford Shipped 15 Jan 10
Is there a way to select
Event_TYPE (Received)
Event_Date (Received)
then select
Event_type (Shipped)
Event_Date (Shipped)
Does this make sense?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry for the delay in answering. Got knocked off.
Thanks for the help!
Thanks for the help!
ASKER
Many thanks,
Open in new window
or
Open in new window