Sofari Agali

Sofari Agali

  • 1.5k
  • 276
  • 26.1k

Sql query error

Apr 13 2022 10:39 AM

hello to all, I have a problem with my sql query which displays null at the level of the 'description' field

here are my 4 tables

tbl_prod (id_prod,description)    tbl_demand( id_dmd,qty_request,qty_served,date_dmd)    tbl_employee(id_emp,name, unit) and intermediate table   tbl_concern(id_prod,id_dmd

I would like my request to show me the tbl_employee.name, tbl_employee.unit, tbl_demand.qty_request, tbl_demand.qty_served, tbl_demand.date_dmd, tbl_prod.description but unfortunately at the level of the chanp description c null which appears, here is my request : 

SELECT description;qty_request,qty_dmd,date_dmd,name,unit from tbl_prod 
right join tbl_concern on tbl_prod.id_prod=tbl_concer.id_prod
right join tbl_demand on tbl_demand.id_dmd=concerne.id_dmd
left join tbl_employee on tbl_employee.id_emp=tbl_dmd.id_emp

can someone help me to see a little more clearly 

thank you


Answers (4)