Excellent. That is working. Apologies for the confusion.

Thank you so much!

Out of interest though, how would I achieve the same when not filtering by location?

For example show all locations with...

Thanks for your reply David.

I was including OEORDD because I will require this table in my final query to do sums.

I filter for location because in my final query I...

Thank you for your replies.

I have modified my SQL statement but still no luck. I still only see the dates from the OEORDH table and no NULL values.

I reckon the...

Thank you for your reply.

My table 'Past12Months' is just a rolling list of the previous 12 months.

YearMonth

201503

201502

201501

201412

201411

201410

201409

201408

201407

201406

201405

201404

The table OEORDH looks like this:

ORDUNIQ | SHIPTO | ORDDATE

1 | 10GEI | 20140512

2...

D'oh, sorry to bring this up again. I thought I had it.

I'm trying to get the description for ROOTASST. Thought that's straight forward but its given me the wrong description...

Thanks Dave!

Great help!

What's your name? CHAMPION!

Awsome, now I finally got it. Thanks so much!

Out of interest: Can I only do this with CTE or can this be done in a normal SQL...

Hi Dave,

thanks for your reply.

Can't get it to work with your code either.

It does not list me the assets which aren't linked to Masterasset1 directly.

It will only go down 1...

Hi Steve,

I meant to show a hierarchie there.

You are right. They should of course all be linked to Masterasset1. I just didn't want to show Masterasset1 repeatedly.

That's the result I...

Hi Dave,

thank you for your quick reply.

This is my table:

Asset | Masterasset

----------------------|

Asset1| Masterasset1

Asset2| Masterasset1

Asset3| Asset2

Asset4| Asset2

In the result I want to show the hierarchie of the assets.

Asset | Masterasset

----------------------|

Asset1| Masterasset1

Asset2|...