[Resolved]Join with a Where clause

i have this sql statment

VB Code:

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

Yes you can. it just goes after the (entire) From clause, so basically after what you have got already.

ok then thanx very much, i tried it and it works