Hi Guys,
Its me again.......
I have written below SQL to list all contracts with invoices to run a report, but unfortunately, it only results contracts with invoices attached to it, but I need the zero ones listed too
How do I achieve this?
SELECT tblProjectContracts.ProjectName, tblProjectContracts.AreaName, tblProjectContracts.Type, tblProjectContracts.Vendor, tblProjectContracts.CtrValue, tblProjectContracts.VOValue, tblProjectContracts.LPOValue, tblProjectContracts.Reference, tblProjectContracts.AreaBudget, tblProjects.ProjectBudget, tblProjectInvoices.InvTotal
FROM (tblProjects RIGHT JOIN tblProjectContracts ON tblProjects.ID = tblProjectContracts.ProjectName) RIGHT JOIN tblProjectInvoices ON tblProjectContracts.id = tblProjectInvoices.Vendor
GROUP BY tblProjectContracts.ProjectName, tblProjectContracts.AreaName, tblProjectContracts.Type, tblProjectContracts.Vendor, tblProjectContracts.CtrValue, tblProjectContracts.VOValue, tblProjectContracts.LPOValue, tblProjectContracts.Reference, tblProjectContracts.AreaBudget, tblProjects.ProjectBudget, tblProjectInvoices.InvTotal;
Thanks in advance,
Erol
Its me again.......
I have written below SQL to list all contracts with invoices to run a report, but unfortunately, it only results contracts with invoices attached to it, but I need the zero ones listed too
How do I achieve this?
SELECT tblProjectContracts.ProjectName, tblProjectContracts.AreaName, tblProjectContracts.Type, tblProjectContracts.Vendor, tblProjectContracts.CtrValue, tblProjectContracts.VOValue, tblProjectContracts.LPOValue, tblProjectContracts.Reference, tblProjectContracts.AreaBudget, tblProjects.ProjectBudget, tblProjectInvoices.InvTotal
FROM (tblProjects RIGHT JOIN tblProjectContracts ON tblProjects.ID = tblProjectContracts.ProjectName) RIGHT JOIN tblProjectInvoices ON tblProjectContracts.id = tblProjectInvoices.Vendor
GROUP BY tblProjectContracts.ProjectName, tblProjectContracts.AreaName, tblProjectContracts.Type, tblProjectContracts.Vendor, tblProjectContracts.CtrValue, tblProjectContracts.VOValue, tblProjectContracts.LPOValue, tblProjectContracts.Reference, tblProjectContracts.AreaBudget, tblProjects.ProjectBudget, tblProjectInvoices.InvTotal;
Thanks in advance,
Erol