[Resolved]Join with a Where clause

[Dubya007]

i have this sql statment

"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]"

i was wondering if i can put a where clause in there? if so where does it go?