Jared,

Thanks for reply. I am having difficulty to join another table, in this case PROJTABLE so on my query results I get the field PROJTABLE.NAME.

PRORJTABLE is linked with PROJEMPLTRANS tablw...

I am back and need some more help to resolve this. From above issue I had I sorted out by making some changes on the Select statement. Results now are...

Thanks Jared for reply. I had tried before FULL JOIN, also FULL OUTER JOIN.

When I run this query I see two issues

1. If the project has forecast for some categories...

LogicWonder: I did try but could not complete it with results for my scenario.

Jared: Thanks for your reply, I have tried your version with my scenario below. I added...

Hello Grasshopper

I am not having any luck with this...pls let me know if you can help me

Thanks for prompt reply and yes you are right that my initial query was a simplified version of this below

Tables:

Dimensions - used for Categories, like Servicing, Engineerring etc

ProjEmplTrans -this holds...

Thanks a lot for your input. I am using Report builder 3.0 and not sur how your suggestion fits to my query. Below I am including my query where result...