StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Try using <code>INNER JOIN</code></p> <pre><code>SELECT ogr.Region_ID, ogr.Region_Name, Sum(daf.Total_Allowance) AS DailyAllowance, Sum(naf.Total_Allowance) AS NightAllowance, Sum(caf.Total_Amount) AS AdvanceCash, Sum(att.Extra_Amounts) AS OverTime, Sum(eef.Total_Amount) AS EmployeeExpense, Sum(maf.Total_Amount) AS MobileAllowance, Sum(odf.On_Week_Amount) AS OnWeek, Sum(emp.Salary) AS EmployeeSalary FROM ORG_Region ogr INNER JOIN DailyAllowanceForm AS daf ON daf.Region_ID = ogr.Region_ID INNER JOIN NightAllowance AS naf ON naf.Region_ID = ogr.Region_ID INNER JOIN CashAdvance AS caf ON caf.Region_ID = ogr.Region_ID INNER JOIN Attandence AS att ON att.Region_ID = ogr.Region_ID INNER JOIN EmployeeExpensesForm AS eef ON eef.Region_ID = ogr.Region_ID INNER JOIN MobileAllowance AS maf ON maf.Region_ID = ogr.Region_ID INNER JOIN OnDutyForms AS odf ON odf.Region_ID = ogr.Region_ID INNER JOIN Employee AS emp ON emp.Region = ogr.Region_ID GROUP BY ogr.Region_ID,ogr.Region_Name </code></pre> <p>Another Way is</p> <pre><code>SELECT ogr.Region_ID , ogr.Region_Name , ( SELECT ISNULL(( SUM(daf.Total_Allowance) ), 0) FROM DailyAllowanceForm AS daf WHERE daf.Region_ID = ogr.Region_ID ) AS DailyAllowance , ( SELECT ISNULL(( SUM(naf.Total_Allowance) ), 0) FROM NightAllowance AS naf WHERE naf.Region_ID = ogr.Region_ID ) AS NightAllowance , ( SELECT ISNULL(( SUM(caf.Total_Amount) ), 0) FROM CashAdvance AS caf WHERE caf.Region_ID = ogr.Region_ID ) AS AdvanceCash , ( SELECT ISNULL(( SUM(att.Extra_Amounts) ), 0) FROM Attandence AS att WHERE att.Region_ID = ogr.Region_ID ) AS OverTime , ( SELECT ISNULL(( SUM(eef.Total_Amount) ), 0) FROM EmployeeExpensesForm AS eef WHERE eef.Region_ID = ogr.Region_ID ) AS EmployeeExpense , ( SELECT ISNULL(( SUM(maf.Total_Amount) ), 0) FROM MobileAllowance AS maf WHERE maf.Region_ID = ogr.Region_ID ) AS MobileAllowance , ( SELECT ISNULL(( SUM(odf.On_Week_Amount) ), 0) FROM OnDutyForms AS odf WHERE odf.Region_ID = ogr.Region_ID ) AS OnWeek , ( SELECT ISNULL(( SUM(emp.Salary) ), 0) FROM Employee AS emp WHERE emp.Region_ID = ogr.Region_ID ) AS EmployeeSalary FROM ORG_Region ogr GROUP BY ogr.Region_ID , ogr.Region_Name </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload