What will be correct SQL query for below question : I have created two table 1st(`Receive_Amount_Details`) for crediting amount from Site(Construction Site) Owner and 2nd(`SitewiseEmployee`) for debiting amount to pay laborer.

I want SUM of all `Amount_Received` from `Receive_Amount_Details`, SUM of `Amount` from `SitewiseEmployee` and single `Date` column as output table.
Here both table have `Date` column, but i want a single column for output.
Output table contain only three column `Date`, `Total_Receive_Amount_from_siteowner` and `Total_Amount_Payed_to_Labour`.
On output table if any single day amount not received and labour payed should be on the output table and also if any single day amount received but not payed to labour also need to come on the output table.


THANKS IN ADVANCE FOR HELP :)

```
CREATE TABLE `Receive_Amount_Details` (
 `Id` int(10) NOT NULL AUTO_INCREMENT,
 `SiteId` int(5) NOT NULL,
 `Amount_Received` int(10) NOT NULL,
 `Date` date NOT NULL,
 PRIMARY KEY (`Id`),
 KEY `SiteId` (`SiteId`),
 CONSTRAINT `Receive_Amount_Details_ibfk_1` FOREIGN KEY (`SiteId`) REFERENCES `SiteList` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
```
and
```
CREATE TABLE `SitewiseEmployee` (
 `Id` int(10) NOT NULL AUTO_INCREMENT,
 `SiteId` int(5) NOT NULL,
 `EmployeeId` int(10) NOT NULL,
 `Amount` varchar(10) DEFAULT NULL,
 `Date` date NOT NULL,
 PRIMARY KEY (`Id`),
 KEY `SiteId` (`SiteId`),
 KEY `EmployeeId` (`EmployeeId`),
 CONSTRAINT `SitewiseEmployee_ibfk_1` FOREIGN KEY (`SiteId`) REFERENCES `SiteList` (`Id`),
 CONSTRAINT `SitewiseEmployee_ibfk_2` FOREIGN KEY (`EmployeeId`) REFERENCES `Employee` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1
```