ratbak

Sorry for the delayed response

What do you want to return and how? Do you want the data flattened (in which case you'll get lots of duplicates at higher levels)?  Do...

Once again, I'm being a numbty - I think you make me nervous hahahahahah

Anyway, I see you've just selected Name and Description for my benefit, as it's not in the...

Hey Phil,

Thanks for reaching out.

My apologies for not be clear.

I copied and pasted your modified code in my dbForge SQL application and I got the following results:

This...

Thanks Scott, much appreciated. Saved me a lot of time and effort

Oops, again, sorry Ken.

Any thoughts from anyone else regarding the error from this query provided by Kevin?

Oops!

Hi Kevin,

Thanks for getting in touch.

I'm getting the following error...

Incorrect syntax near ')'.

Thanks for responding...

Thank you

Hi Jonathon,

tbl_probate_case does not have column named case_submitted_date.

I very clever person on another forum has already advised me that the problem was the missing column. The thrust behind this question...

Hi Brian,

I hope the person that originally told me what the problem doesn't read this post, as he was extremely helpful and I don't want to undermine him. But I...

I should mention the following is the code it is RAW PL / SQL format that works in production

SELECT m.ce_case_data_id, -- AS case_data_id
    ...

Thanks all for you're contribution. I realise there are too many unknowns for this question to be properly addressed. Therefore, I would be happy for the administrator of this forum...

Thank you Jeff. Spot on. Thanks