I have two tables, and am doing an ordered select on each of them. I wold like to see the results of both orders in one result.

Example (simplified):

```
"SELECT * FROM table1 ORDER BY visits;"
name|# of visits
----+-----------
 AA | 5
 BB | 9
 CC | 12
.
.
.

"SELECT * FROM table2 ORDER BY spent;"
name|$ spent
----+-------
 AA | 20
 CC | 30
 BB | 50
.
.
.

```

I want to display the results as two columns so I can visually get a feeling if the most frequent visitors are also the best buyers. (I know this example is bad DB design and not a real scenario. It is an example)

I want to get this:

```
name by visits|name by spent
--------------+-------------
 AA           | AA
 BB           | CC
 CC           | BB

```

I am using SQLite.