Please ALWAYS include create table statements and all relevant sample data and your expected output from said data. That way we can be sure to write a query that covers all of your needs, and ask intelligent questions if we are uncertain.