I want help on this. I'm using MS Access DB

TIA

I want to combine these 2 SQL queries to get a single output.

```
select a.salesid, salesdate, customername, sum(qty*price)  
from tblsales a 
inner join tblsales_details b on b.salesid = a.salesid 
where customername like '%arvin%' 
group by a.salesid, salesdate, customername

```

Result:

```
001 1/1/1970 arvin 109500

```

Query #2:

```
select a.salesid, sum(b.pamount) as payment 
from tblsales a 
inner join tblpayments b on b.salesid = a.salesid 
where customername like '%arvin%' 
group by a.salesid

```

Result:

```
001 105000

```

I want the result will be like this

```
001 1/1/1970 arvin 109500 105000

```

TIA