I have table that has to be joined to another table based on the state. Here is example of the table 1 data:

```
ROWID  STATE 
 34     TX
 56     NY
 67     WA
 89     TX

```

Each row in table one has state value. Table 2 has two records for each state. Here is example:

```
ROWID   STATE       NAME  
 19      TX     Chuck, Brown
 20      TX     Nick, Johnes 

```

As you can see in Table 2 there are two records for Texas state. If I use `Left Outer Join` and try to do something like this:

```
LEFT OUTER JOIN Table 2 TB2
   ON TB1.STATE = TB2.SATE

```

Then the output will be something like this:

```
34 TX Chuck, Brwon
34 TX Nick, Johnes
89 TX Chuck, Brwon
89 TX Nick, Johnes

```

Each row is duplicated, since I have two records in Table 1 for Texas. Then I have two records in Table 2 for Texas. What I would like to see is this:

```
ROWID   STATE     NAME 1         NAME 2
 34      TX    Chuck, Brwon    Nick, Johnes

```

Basically I want to merge two rows in one and then join to TABLE 1. I recently started working on this project and we use Oracle database. If anyone know good way to achieve this please let me know. Thank you.