MySQL Forums
Forum List  »  Views

Re: Help with conceptualizing a query
Posted by: Bodi K
Date: November 18, 2013 01:20PM

Thanks for the reply Peter.

No, it's not quite what I needed, I don't think. Although that gets me the min and max phase numbers, it doesn't combine them into a single query. Even if I were to join them in some intelligent way, I don't see how that would the yield the list as I need it.

To reiterate...

I need a unique list of all the tasks within phases 1-X (X is specified). The result set needs to have a column indicating if it appears in the X phase and a column indicating which phase it first appeared in.

Thanks for any other suggestions...

Options: ReplyQuote

Written By
November 14, 2013 03:24PM
November 17, 2013 12:10AM
Re: Help with conceptualizing a query
November 18, 2013 01:20PM
November 18, 2013 09:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.