Hi
How is it possible to join a function returnin a table with a table?
If i write :
Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(Document.IdDoc) F on Document.IdDoc = F.IdDoc
i get an error "Incorrect syntax near '.'"
If i write
Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(IdDoc) F on Document.IdDoc = F.IdDoc
i get an error
'IdDoc' is not a recognized OPTIMIZER LOCK HINTS option.
Someone could help me?
thanks
How is it possible to join a function returnin a table with a table?
If i write :
Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(Document.IdDoc) F on Document.IdDoc = F.IdDoc
i get an error "Incorrect syntax near '.'"
If i write
Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(IdDoc) F on Document.IdDoc = F.IdDoc
i get an error
'IdDoc' is not a recognized OPTIMIZER LOCK HINTS option.
Someone could help me?
thanks