Join tables with empty records

[liveevil]

Hi all,

I'm trying to join 2 tables as follow

Table 1:
userId Name
1 Tom
2 John

Table 2:
bookId userId Title
1 1 Book1
2 1 Book2

Ultimately, I need a table which shows the record even if it does not have a corresponding record in Table2.

My desired result:
userId Name bookId Title
1 Tom 1 Book1
1 Tom 2 Book2
2 John

I tried to use Join statement but what happened is since userId 2 does not have a record in Table2, it doesnt show in my results. Is there anything i can do to make this works?

[rski]

Instead join use

table1 left outer join table2