Thanks. But the above sql doesn't quite work as d1, d2 etc.. are not bound to any table

Thanks for the replies. Not sure whether this makes a difference but I think I needed to also add:

the joins on LookUpTbl2 is required only for those columns in Meter...

Yes I was intending to convert to sqlserver.

I managed to figure this out. Ts_summary was a custom function. All sorted.

Thanks.