Hi, I am trying the following SQL to fetch the needed data. The query works in query analyzer in SQL Server 2005. But in data adapter in a dataset in Visual Studio 2005, I am getting the data with all other empty cells. What mistake I am doing? The expected result is only a concatenated value (~/images/logos/Somelogo.jpg)

Code:
SELECT (SELECT FilePath FROM dbo.FilePaths WHERE (FilePathID = dbo.Brands.BrandLogoImageFilePath)) + BrandLogoImageName
...