I’m not good at SQL. when I want to query these jobs by project but don’t know which command to use to connect the tables together.
Where does not have the same keys to connect. Can anyone help me?
SELECT llx_projet.title,llx_projet.ref, llx_projet_task.datee, llx_projet.opp_amount, llx_projet_extrafields.nguoi_quan_ly, llx_paiement.amount, llx_projet.description,llx_projet_task.label
FROM llx_projet, llx_projet_task, llx_paiement, llx_projet_extrafields
