I have 2 tables A, B 

Table A: 

```
ID      Value1   Value2
------------------------
1000     10        25
1001      4        12
1002      2         6
1003      1         8

```

Table B: 

```
ID      Value3   Value4
------------------------
1000     51        12
1003      3        10

```

What I need is to show the below result:

```
ID     Value1   Value2   Value3   Value4
-----------------------------------------
1000    10       25       51       12
1001     4       12       NULL     NULL
1002     2        6       NULL     NULL
1003     1        8        3       10

```

The query I've tried:

```
SELECT I.AgentId AS AGENT
    ,COUNT(I.Indice) AS [Number of Inbound calls]
    ,AVG(I.WrapupDuration) AS [AVG Wrapup IN]
    ,COUNT(O.Indice) AS [Number of Out calls]
    ,AVG(O.WrapupDuration) AS [AVG Wrapup Out]
FROM [HN_Ondata].[dbo].[vwInboundCalls] I
LEFT JOIN [HN_Ondata].[dbo].vwOutboundCalls O
    ON I.AgentId = O.AgentId
GROUP BY I.AgentId

```