My brain is not working this morning! Can someone please help me with an sql statement that will join the following two tables:

Table 1:
projectid
project name
etc...

Table 2:
projectid
actionid
action
adate

What I want is a cursor that combines all of the projects from Table 1 with the corresponding actionid, action, and adate from Table 2. I want to include all projects from table 1 regardless of whether it has any actions in Table 2. Hope this makes sense.

Thanks in advance,
Russell