I have the following selection:
> SELECT CONCAT('Applicant's Name: ',AppID, CHAR(13) + CHAR(10)+'Application Date: ',AppDate, > CHAR(13) + CHAR(10)+'The products are: ',@Products) AS Body > FROM tblApplication > WHERE Appno=@Appno
Products is not a member of tblApplictions but should be a list returned from the following:
> DECLARE @Products AS NVARCHAR(1000)
SELECT @Products = ProductDescr
> FROM tblProducts INNER JOIN tblApplication
> WHERE Appno=@Appno
The problem is I only get one record of products. Any kind of help would be appreciated.
Thank you in advance.