0

Hello thanks in advance
i working on project

i used query
select project_table.project_id as proid,resource_request.,sum(resource_table.resource_budget)as resourcecost,resource_table. from project_table left join resource_request on resource_request.project_id = resource_request.project_id left join resource_table on resource_table.resource_id = resource_request.resource_id GROUP BY proid
ORDER BY proid DESC

its worked but resourcecost is displaying for all project id if there is no resource used in project thnaks in advance

table is something like this
project table have project_id
resource_table have resource_id

and last table
resource_resquest hace project_id and resource_id

2
Contributors
2
Replies
9
Views
3 Years
Discussion Span
Last Post by durgesh1
0

You have an error in your SQL query, if what you have written above is an exact copy of your code.
You have "from project_table left join resource_request on resource_request.project_id = resource_request.project_id"

You haven't included project_table in the ON clause, instaed you have referenced resource_request twice. This will cause your query to give some unexpected results.

0

thanks
and sorry for my silly mistake

Edited by durgesh1: hg

Attachments ee.png 182.19 KB
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.