sql - Errors in WHERE clause near 'FOR'

Question

Looking for some assistance on how to resolve the error in my query.

(SELECT     TRANSFERID + '/' AS 'data()'
                        FROM          GNC_DYNAX09_Live.dbo.INVENTTRANSFERTABLE
                         WHERE      (DATAAREAID = 'gnc') AND (MRTPRODIDREFERENCE = b1.PRODID FOR XML PATH(' ')) ' - No matching transfers') 
                  AS [Batch Number / Transfer]

question from:https://stackoverflow.com/questions/65942215/errors-in-where-clause-near-for

Answer 1

Waitting for answers