Join with a Top1 one
Posted on 2011-09-02
I am a pretty complex view that I am working with and now I need to add an additional join to the view.
I basically have a table with projects, but now I want to add another table that should only have one record per project, but there could be more. The records in the new table will tell me if a calculation should be made or not.
here is what I am trying to do, but it isnt working
LEFT JOIN (SELECT TOP 1 Projectnumber AS projectnumber, status, hid FROM dbo.Absences WHERE TYPE = 232 )
AS a ON projectnumber=prproject.projectnr