I'm trying to join a table with a conditional statement.

Basically I want to select all the info from a row in table1 AND select a field from table2 whether it is in table1 or not.

I'm not sure I'm explaining this right, here's how I want it to look:

t1.field1 t1.field2 t2.field1
1 1 1
2 1
3 1 1

So it will give me null if there is no row in table2 that joins with table1.

Any help is greatly appreciated.