I have Three tables that are all tied by the key from the first table like this. I have use <-- to signify which field from each table contains the value that ties it to the previous field. I have tried a query with a nest inside of a nest in Server-Connect but I can’t make it work.
Table One.
Jobs:
Job_id <–
Job_name_table
Mob_address
and so on…
Table two:
Job_products_table
job_products_id
job_products_job_id <–
job_products_name
job_products_quantity
Table Three:
Job_shipment_table
job_shipment_id
job_shipment_product_id
job_shipment_job_id <–
job_shipment_tracking_number
job_shipment_quantity
The query I am trying to create will list the job by job_id, Job_products_table where job_products_job_id == jobs_table job_id, and job_shipment where job_shipment_job_id == jobs_table job_id. I need the SUM of the job products table ‘job_products_quantity’ field and the SUM of the job_shipments_quantity field.
The result should be like this:
Job Number: 2323
Total product Quantity: 20
Total products Shipped: 14
then something like;
Remain items to ship: 6
repeat…
repeat…
Any help with this would be greatly appreciated.
Last updated: