Query for report generation from multiple tables

[anuragvatsa]

hi,
how to write query to select project estimated effort,actual effort spent,%usage of project effort,%complet ion of project,ratio of %work completion to % effort consumed FOR

1. during the period
2. Cumulative period
All the differnt kind of effort comes from multiple tables

thanks
Eagle A,

[code green]

With a SELECT query along with JOIN