Using SQL, how can I get the actual row number of the data from the Master table, when I combined two tables (Master-table and Table-2). Please see illustration below:

Table-1 (Master Table)

```

    Name       Age
   ---------- ------     
1   Ruth     | 45
2   Jennifer | 52
3   Isabel   | 29
4   Jo       | 59
5   Dan      | 35
6   Lem      | 26

```

Table-2

```

    Name       Color
   ---------- ------       
1   Ruth     | Blue
2   Jennifer | Blue
3   Isabel   | Red
4   Jo       | Blue
5   Dan      | Red
6   Lem      | Blue

```

The result I want to get: (1) get records where color is blue, (2) new column (Row\_Number from Table-1):

```

    Name       Age    Color    Row_Number
   ---------- ------ -------- ------------
1   Ruth     | 45   | Blue   | 1
2   Jennifer | 52   | Blue   | 2
3   Jo       | 59   | Blue   | 4
4   Lem      | 26   | Blue   | 6

```