I have

```
<table1>
column1 column2
   1       A
   2       B
   2       C

<table2>
column3 column4
   1       C
   2       D

```

When I do left join

```
SELECT table1.column1,
       table1.column2,
       table2.column4
FROM table1
LEFT JOIN table2 ON table1.column1 = table2.column3

```

I get

```
column1 column2 column4
   1        A      C
   2        B      D
   2        C      D

```

Would it be possible to instead somehow get the output as,

```
column1 column2 column4
   1        A      C
   2        B      
   2        C      D

```

I want that for every repeated table1.column1, the table2.column4 should come only once and the remaining times it comes out blank.

I have tried various things but haven't succeeded in any.