JOIN columns with no data

Hi All,

I am trying to create a fairly large join (7 tables) that needs to allow NULL
in columns.

Table 1
1 | A | 2
2 | B | 3

JOINed with

Table 2
1 | note

should output
1 | A | 2 | note
2 | B | 3 |

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com