open more than one table

[Dubya007]

um..............i've never done a stored procedure, i have heard of them but i donno how in the world to even start to do one.

i put in the left join Select statement and i got a syntax error @ the word left.

OpenSQL = "SELECT [Tool Data].ToolNumber, [Tool Data].[Drawing Number],[Tool Data].[Type of Tool], [Tool data].[Die Type]," & _
              "[Tool Data].[Date Created], [Tool Data].Vendor, [Tool Data].Department, [Tool Data].[Tool Number assigned by]," & _
              "[Tool Data].PSketch, [Tool Data].[Storage Location],[Tool Data].PMType,Status.Description,Status.Status, Status.Date" & _
              "FROM [Tool Data] LEFT JOIN [Status] ON [Tool Data].ToolNumber = Status.[Tool number]"