I have a table that contains the following columns:

1. ID
2. Master ID

The Master ID can be shared between different rows with different IDs.

E.g.:

```
ID | Master ID
1  |  1
2  |  1
3  |  1
4  |  2

```

Knowing the ID I want to retrieve all the rows that share the same master ID

I managed to do it using this query:

```
Select * 
FROM table t
LEFT JOIN table t2
ON t.MASTER_ID = t2.MASTER_ID 
Where t.ID = '1'

```

Then I also tried using: 

```
Select * 
FROM table t
LEFT JOIN table t2
ON t.MASTER_ID = t2.MASTER_ID and t.ID = '1'

```

In that case, it was much slower. Can anyone explain why?