0

I'm trying to make this work but looks I'm doing something wrong, I've already looked around and can't find or figure out a solution! Sorry I'm just new on programing; Got 4 tables and I need to pull some information out :

From table 1 (worksheetsDetails): I need the product_id product_designation and SUM(product_quantity) ordered by product_designation.

From Table 2 (worksheets): I need to get the worksheet_id from where the table 1 are related.

From table 3 (products): I need to get the product_price from products who are in the first table and pull a sum of all the products together where the table 4 (work_sites) worksite_id is related.

worksite_id from worksites is related to worksheets table.

I came this far:

SELECT 
    product_id, 
    product_description, 
    SUM(product_quantity) AS quantity 
FROM 
    app_com_worksheetDetails 
LEFT JOIN 
    app_com_worksheet
ON 
    app_com_worksheet.worksheet_id = pp_com_worksheetDetails.worksheet_id
WHERE 
    app_com_worksheet.worksite_id = '$wsi_id'       
GROUP BY 
    product_description"

And I'm getting that error!

Please someone can hepl?

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
Branco
  • 1

0 Answers0