I had a little problem in querying something. When defining a project you use work items. And a work item may use a material, labor and equipment. It may not use one or two of them for that work item when it is defined.

So for that work item you will define a performance rate, just a value given for that work item in the defined project, it varies project from project.

So when i want to define a performance rate i want to query all the work items used in that project from the three tables,remember that i may or may not use the above items for that work item under that defined project.

How can i achieve that?

How far did you do? Post your codes for querry.