Q: Getting Select Query Result in a single row MS Access 2010 I am trying to get select query result in a single row, but its giving me a syntax error
Here is the query
SELECT csv.ControlKey+'|' +csv.ControlName+'|'+fs.SheetName+'||' AS Result
From CSVData as csv
Inner Join FilesSheets as fs
ON csv.FileId=fs.FileId
AND csv.SheetNo=fs.SheetNo
Where csv.FileId='(20101010)20Y-27-22170_4Ħ_20151215101623.xls'
For xml path('')

Here is the syntax error

But if I remove For xml path('') from query it works fine but return multiple rows
