I am performing MySQL functions using PHP for my webpages.

I have got a table 

```
table name -> users

 uname     oname
  john      alex
  john      murray
  john      joseph
  john      ray

```

and another table

```
table name -> more_info

fname    lname         more
 alex     some name   some info
 murray     //           //
 joseph     //           //
 ray       //            //

```

What I am trying to do is to run a query 

Retrieve all the `oname` column values which are matched with `uname` john

This statement successfully retrieves the oname column values if uname = john

```
SELECT oname FROM users WHERE uname = 'john '

```

Now I want a statement something like this, based on the previously retrieved oname column values 

```
SELECT * FROM more_info WHERE fname=oname // previos ones 

```

I guess its `Join` or`innerJoin` but somehow I am unable to get the correct syntax of it or any other simple query to do this.

**My approach**

I thought to retrieve the oname column values first and then inside a for loop, based on number of rows returned run a query for each column, but this approach eats up my server.