Call TVF on each table entry and compelling results

Question

I thought this should be obvious, but I cannot understand.

Let's say that there is a table tblDatawith a column IDand a table function ( _tvf) that takes a parameter ID. I need results for all ID's tblData.

But:

SELECT * FROM tblData data 
INNER JOIN dbo._tvf(data.ID) AS tvfData
   ON data.ID = tvfData.ID

gives me an error: The multi-part identifier "data.ID" could not be bound

What is the correct way to transfer all IDs to this TVF and reconcile the results?

thank

Answer 1

I think you might need to use CROSS APPLY instead of an inner join here:

SELECT * 
FROM dbo.tblData data 
CROSS APPLY dbo._tvf(data.ID) AS tvfData

TVF data.ID .

. :

• CROSS APPLY SQL Server
• APPLY SQL Server
• T-SQL CROSS APPLY OUTER APPLY