SELECT 
First_Name + ' ' + Last_Name + ' har hyrt ' ,
(SELECT COUNT(CAST(person_id AS Varchar(5))) 
FROM Lending where person_id=2)
, 'st film(er)' 
FROM person WHERE id=2;

SELECT 
First_Name + ' ' + Last_Name + ' har hyrt ' 
+	(SELECT COUNT(CAST(person_id AS Varchar(5))) 
	FROM Lending where person_id=2)
+ 'st film(er)' 
FROM person WHERE id=2;

quote:

---

Originally posted by Azaera

Hiya.

I'm trying to get a nice concat and union to work togheter, but gets a little bit of trouble, so a bit of help would be apprecitated.

I have to get the firstname and lastname togheter with a count into one single column and then union them with different movies.

Banged my head now, and since it is school, I would prefer the kicks right rather then full code.
The best I've been able to do is:

SELECT
First_Name + ' ' + Last_Name + ' har hyrt ' ,
(SELECT COUNT(CAST(person_id AS Varchar(5)))
FROM Lending where person_id=2)
, 'st film(er)'
FROM person WHERE id=2;

SELECT Lending.Lending_TimePoint, Movie.Title
FROM Lending INNER JOIN Movie
ON Lending.Item_id = Movie.Id
WHERE Person_id=2
ORDER BY Lending.Lending_TimePoint;

But this gives me three columns in the first code bit but dislikes the union tpo the second since I don't have equal numbers of expressions.

---