If I have two tables(t1, t2), each with one column

```
t1      
letters  
a         
b         
c         

t2
nums
1
2
3

```

Is it possible to "join" the two together in a way that produces a two-column result set that looks like this:

```
letters nums
a       1
b       2
c       3

```

Requirements for the solution:

* Must combine each table's data in a specified order, so being able
to order each table's data before joining
* Doesn't use any functions, like row\_number, to add an extra column to join on

Bonus points:
 - If two tables have different row counts, final result set is count of the max of the two tables, and the "missing" data is nulls.

Just wondering if this is possible given the constraints.